APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_APPLICATIONS

Line 115: FROM per_applications apl

111: )
112: IS
113: SELECT apl.application_id
114: ,apl.object_version_number
115: FROM per_applications apl
116: WHERE apl.person_id = csr_apl_details.p_person_id
117: AND csr_apl_details.p_effective_date BETWEEN apl.date_received
118: AND NVL(apl.date_end,hr_api.g_eot);
119: --

Line 1509: l_application_id per_applications.application_id%TYPE;

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;
1513: --

Line 1510: l_apl_object_version_number per_applications.application_id%TYPE;

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;
1513: --
1514: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 1588: per_applications pap

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
1591: and per.person_id = pap.person_id
1592: and per.person_id = p_person_id