eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_EOY_VAL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1814: from hr_all_organization_units

1810:
1811: --Legal Entity Name
1812: select name
1813: into l_legal_entity
1814: from hr_all_organization_units
1815: where organization_id=P_LEGAL_ENTITY;
1816:
1817: --Certificate Type
1818: select meaning

Line 3169: l_org_location_id hr_all_organization_units.location_id%type;

3165: l_location_id per_all_assignments_f.location_id%type;
3166: l_position_id per_all_assignments_f.position_id%type;
3167: l_organization_id per_all_assignments_f.organization_id%type;
3168: l_pos_location_id per_all_positions.location_id%type;
3169: l_org_location_id hr_all_organization_units.location_id%type;
3170: l_passport_no varchar2(150);
3171: l_country_passport varchar2(150);
3172: l_id_dob number(1);
3173: l_it_no_val number(1);

Line 3239: from hr_all_organization_units haou

3235: (select pap.location_id
3236: from per_all_positions pap
3237: where pap.position_id = ass.position_id) pos_location_id,
3238: (select haou.location_id
3239: from hr_all_organization_units haou
3240: where haou.organization_id=ass.organization_id) org_location_id
3241: from
3242: per_assignments_f ass,
3243: per_all_people_f per,