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.HR_EMPLOYEE_APPLICANT_API dependencies on PER_BUSINESS_GROUPS

Line 100: ,per_business_groups bus

96: ,per.npw_number
97: ,bus.business_group_id
98: ,bus.legislation_code
99: FROM per_people_f per
100: ,per_business_groups bus
101: ,per_person_types pet
102: WHERE per.person_type_id = pet.person_type_id
103: AND per.business_group_id+0 = bus.business_group_id
104: AND per.person_id = csr_per_details.p_person_id

Line 1508: l_legislation_code per_business_groups.legislation_code%TYPE;

1504: l_primary_assignment_id number:=p_primary_assignment_id;
1505: --
1506: l_system_person_type per_person_types.system_person_type%TYPE;
1507: l_business_group_id per_all_people_f.business_group_id%TYPE;
1508: l_legislation_code per_business_groups.legislation_code%TYPE;
1509: l_application_id per_applications.application_id%TYPE;
1510: l_apl_object_version_number per_applications.application_id%TYPE;
1511: --
1512: l_hire_date date;

Line 1586: per_business_groups bus,

1582: per.npw_number,
1583: pap.application_id,
1584: pap.object_version_number
1585: from per_all_people_f per,
1586: per_business_groups bus,
1587: per_person_types ppt,
1588: per_applications pap
1589: where per.person_type_id = ppt.person_type_id
1590: and per.business_group_id = bus.business_group_id