DBA Data[Home] [Help]

APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on HR_ORGANIZATION_UNITS

Line 649: hr_organization_units hou,

645: cursor c_get_gre_id(cp_bg_id number,cp_gre_name varchar2) IS
646:
647: SELECT hout.organization_id
648: FROM hr_organization_information hoi,
649: hr_organization_units hou,
650: hr_all_organization_units_tl hout
651: WHERE hoi.organization_id = hou.organization_id
652: AND hou.organization_id = hout.organization_id
653: AND hoi.ORG_INFORMATION_CONTEXT = 'CLASS'