JL Brazilian Opening and Closing Pages

	 select
		A.NAME,  
		A.ADDRESS_LINE_1,		
		A.ADDRESS_LINE_2,
		A.ADDRESS_LINE_3,		
		A.TOWN_OR_CITY	,		
		A.REGISTRATION_NUMBER,	
		To_Char (fnd_conc_date.STRING_TO_DATE(A.EFFECTIVE_FROM), 'DD-MON-YY' ) EFFECTIVE_FROM ,			
		(select H.LOCATION_CODE from HR_LOCATIONS H where H.LOCATION_ID = A.LOCATION_ID ) LOCATION
	 from XLE_FIRSTPARTY_INFORMATION_V A , GL_LEDGER_LE_V G
	 where A.LEGAL_ENTITY_ID=  :P_LEGAL_ENTITY_ID
		and A.LEGAL_ENTITY_ID = G.legal_entity_id
		and G.LEDGER_ID =  :P_LEDGER_ID