373: HrLoc.Global_Attribute11||HrLoc.Global_Attribute12 HR_REP_TYPE_INFO_LAT,
374: HrLoc.Global_Attribute1 HR_REP_TYPE_INFO_KOR,
375: HrLoc.Global_Attribute2 HR_REP_TYPE_INFO_EUR_GRC
376: FROM Hr_Locations_All HrLoc
377: ,xle_etb_profiles XEP
378: ,xle_associations xa
379: ,xle_association_types atype
380: ,xle_assoc_object_types ctype_obj
381: ,xle_assoc_object_types ctype_sub
809: ,Sysdate -- Who Column
810: ,Fnd_Global.Conc_Login_Id -- Who Column
811: ,1
812: FROM Hr_Locations_All HrLoc
813: ,xle_etb_profiles XEP
814: ,xle_associations xa
815: ,xle_association_types atype
816: ,xle_assoc_object_types ctype_obj
817: ,xle_assoc_object_types ctype_sub
917: ,Fnd_Global.Conc_Login_Id -- Who Column
918: ,1
919: FROM
920: Hr_Locations_All HrLoc
921: ,xle_etb_profiles XEP
922: ,Hr_All_Organization_Units HrOU
923: ,Hr_Organization_Information HrOrgInfo
924: ,Financials_System_Params_All Fso
925: ,Ap_System_Parameters_All ASP
1112: ,1
1113: FROM
1114: jl_br_company_infos jl
1115: ,gl_ledger_le_v gl
1116: ,xle_etb_profiles etb
1117: ,zx_party_tax_profile ptp
1118: WHERE
1119: jl.INACTIVE_DATE is null
1120: and jl.set_of_books_id = gl.ledger_id
1203: ,1
1204: FROM
1205: jl_br_company_infos jl
1206: ,gl_ledger_le_v gl
1207: ,xle_etb_profiles etb
1208: ,zx_party_tax_profile ptp
1209: WHERE
1210: jl.INACTIVE_DATE is null
1211: and jl.set_of_books_id = gl.ledger_id
1278: ,1
1279: FROM
1280: jl_br_company_infos jl
1281: ,gl_ledger_le_v gl
1282: ,xle_etb_profiles etb
1283: ,zx_party_tax_profile ptp
1284: WHERE
1285: jl.INACTIVE_DATE is null
1286: and jl.set_of_books_id = gl.ledger_id