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.

[Home] [Help]

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 1723: l_application_id per_applications.application_id%TYPE;

1719: --
1720: l_system_person_type per_person_types.system_person_type%TYPE;
1721: l_business_group_id per_all_people_f.business_group_id%TYPE;
1722: l_legislation_code per_business_groups.legislation_code%TYPE;
1723: l_application_id per_applications.application_id%TYPE;
1724: l_apl_object_version_number per_applications.application_id%TYPE;
1725: --
1726: l_hire_date date;
1727: --

Line 1724: l_apl_object_version_number per_applications.application_id%TYPE;

1720: l_system_person_type per_person_types.system_person_type%TYPE;
1721: l_business_group_id per_all_people_f.business_group_id%TYPE;
1722: l_legislation_code per_business_groups.legislation_code%TYPE;
1723: l_application_id per_applications.application_id%TYPE;
1724: l_apl_object_version_number per_applications.application_id%TYPE;
1725: --
1726: l_hire_date date;
1727: --
1728: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 1809: per_applications pap

1805: pap.object_version_number
1806: from per_all_people_f per,
1807: per_business_groups bus,
1808: per_person_types ppt,
1809: per_applications pap
1810: where per.person_type_id = ppt.person_type_id
1811: and per.business_group_id = bus.business_group_id
1812: and per.person_id = pap.person_id
1813: and per.person_id = p_person_id

Line 2018: from per_applications

2014: and effective_start_date >= p_hire_date;
2015:
2016: cursor csr_get_apln_details(p_hire_date date) is
2017: select date_received,date_end
2018: from per_applications
2019: where person_id= p_person_id and date_received > p_hire_date;
2020:
2021: cursor csr_back_toback_apln(p_date_end date) is
2022: select 'Y' from per_applications

Line 2022: select 'Y' from per_applications

2018: from per_applications
2019: where person_id= p_person_id and date_received > p_hire_date;
2020:
2021: cursor csr_back_toback_apln(p_date_end date) is
2022: select 'Y' from per_applications
2023: where person_id = p_person_id
2024: and date_received = p_date_end +1;
2025:
2026: cursor fut_asg_rec is

Line 2036: select application_id, date_end from per_applications

2032: and application_id = l_application_id
2033: order by effective_start_date;
2034:
2035: cursor chk_apl_exists(p_asg_start_date date) is
2036: select application_id, date_end from per_applications
2037: where person_id = p_person_id
2038: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
2039: -- ER FPT
2040:

Line 3729: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;

3725: fetch chk_apl_exists into l_cur_apl_id, l_current_apl_end_date;
3726: if chk_apl_exists%notfound then
3727:
3728: -- creating APLN since not found
3729: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
3730: l_cur_apl_id := l_new_application_id;
3731: begin
3732: INSERT INTO PER_APPLICATIONS(
3733: application_id,

Line 3732: INSERT INTO PER_APPLICATIONS(

3728: -- creating APLN since not found
3729: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
3730: l_cur_apl_id := l_new_application_id;
3731: begin
3732: INSERT INTO PER_APPLICATIONS(
3733: application_id,
3734: business_group_id,
3735: person_id,
3736: date_received,

Line 3750: update per_applications

3746: else
3747:
3748: -- if APLN end date < ASG end date, update the APLN
3749: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then
3750: update per_applications
3751: set date_end = l_apl_end_date
3752: where person_id = p_person_id
3753: and application_id = l_cur_apl_id;
3754: end if;

Line 4188: l_application_id per_applications.application_id%TYPE;

4184: --
4185: l_system_person_type per_person_types.system_person_type%TYPE;
4186: l_business_group_id per_all_people_f.business_group_id%TYPE;
4187: l_legislation_code per_business_groups.legislation_code%TYPE;
4188: l_application_id per_applications.application_id%TYPE;
4189: l_apl_object_version_number per_applications.application_id%TYPE;
4190: --
4191: l_hire_date date;
4192: --

Line 4189: l_apl_object_version_number per_applications.application_id%TYPE;

4185: l_system_person_type per_person_types.system_person_type%TYPE;
4186: l_business_group_id per_all_people_f.business_group_id%TYPE;
4187: l_legislation_code per_business_groups.legislation_code%TYPE;
4188: l_application_id per_applications.application_id%TYPE;
4189: l_apl_object_version_number per_applications.application_id%TYPE;
4190: --
4191: l_hire_date date;
4192: --
4193: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 4282: per_applications pap

4278: pap.object_version_number
4279: from per_all_people_f per,
4280: per_business_groups bus,
4281: per_person_types ppt,
4282: per_applications pap
4283: where per.person_type_id = ppt.person_type_id
4284: and per.business_group_id = bus.business_group_id
4285: and per.person_id = pap.person_id
4286: and per.person_id = p_person_id

Line 4548: from per_applications

4544: and effective_start_date >= p_hire_date;
4545:
4546: cursor csr_get_apln_details(p_hire_date date) is
4547: select date_received,date_end
4548: from per_applications
4549: where person_id= p_person_id and date_received > p_hire_date;
4550:
4551: cursor csr_back_toback_apln(p_date_end date) is
4552: select 'Y' from per_applications

Line 4552: select 'Y' from per_applications

4548: from per_applications
4549: where person_id= p_person_id and date_received > p_hire_date;
4550:
4551: cursor csr_back_toback_apln(p_date_end date) is
4552: select 'Y' from per_applications
4553: where person_id = p_person_id
4554: and date_received = p_date_end +1;
4555:
4556: cursor fut_asg_rec is

Line 4566: select application_id, date_end from per_applications

4562: and application_id = l_application_id
4563: order by effective_start_date;
4564:
4565: cursor chk_apl_exists(p_asg_start_date date) is
4566: select application_id, date_end from per_applications
4567: where person_id = p_person_id
4568: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
4569:
4570: -- ER FPT

Line 6574: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;

6570: fetch chk_apl_exists into l_cur_apl_id, l_current_apl_end_date;
6571: if chk_apl_exists%notfound then
6572:
6573: -- creating APLN since not found
6574: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
6575: l_cur_apl_id := l_new_application_id;
6576: begin
6577: INSERT INTO PER_APPLICATIONS(
6578: application_id,

Line 6577: INSERT INTO PER_APPLICATIONS(

6573: -- creating APLN since not found
6574: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
6575: l_cur_apl_id := l_new_application_id;
6576: begin
6577: INSERT INTO PER_APPLICATIONS(
6578: application_id,
6579: business_group_id,
6580: person_id,
6581: date_received,

Line 6595: update per_applications

6591: else
6592:
6593: -- if APLN end date < ASG end date, update the APLN
6594: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then
6595: update per_applications
6596: set date_end = l_apl_end_date
6597: where person_id = p_person_id
6598: and application_id = l_cur_apl_id;
6599: end if;