DBA Data[Home] [Help]

APPS.XLE_BUSINESSINFO_GRP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 644: FROM hr_all_organization_units o,

640: with a Ledger */
641:
642: cursor OperUnit_c is
643: SELECT o.organization_id operating_unit_id
644: FROM hr_all_organization_units o,
645: hr_organization_information o2,
646: hr_organization_information o3
647: WHERE o.organization_id = o2.organization_id
648: AND o.organization_id = o3.organization_id

Line 682: FROM hr_all_organization_units o,

678: /* Select ledger associated with the Operating unit*/
679:
680: SELECT DISTINCT o3.org_information3
681: INTO l_ledger_id
682: FROM hr_all_organization_units o,
683: hr_organization_information o2,
684: hr_organization_information o3
685: WHERE o.organization_id = o2.organization_id
686: AND o.organization_id = o3.organization_id

Line 1156: FROM hr_all_organization_units o,

1152: begin
1153:
1154: SELECT o3.org_information3
1155: INTO l_ledger_id
1156: FROM hr_all_organization_units o,
1157: hr_organization_information o2,
1158: hr_organization_information o3
1159: WHERE o.organization_id = o2.organization_id
1160: AND o.organization_id = o3.organization_id