APPS.PER_PDS_BUS dependencies on PER_ALL_PEOPLE_F

Line 136: from per_all_people_f per

132: order by 1 desc;
133: --
134: cursor csr_get_max_per_eff_date is
135: select max(per.effective_start_date)
136: from per_all_people_f per
137: where per.person_id = p_person_id;
138: -- ER FPT
139: cursor not_allowed_ppt is
140: select ptu.effective_start_date

Line 1350: -- PER_ALL_PEOPLE_F where PERSON_SYSTEM_TYPE in ('EMP', 'EMP_APL')

1346: -- Description:
1347: -- Validates that the following business rules are met:
1348: -- a) PERSON_ID and DATE_START combination must be unique (I)
1349: -- b) PERSON_ID and DATE_START combination must exist in
1350: -- PER_ALL_PEOPLE_F where PERSON_SYSTEM_TYPE in ('EMP', 'EMP_APL')
1351: -- (I,U)
1352: --
1353: -- Pre-conditions:
1354: -- person_id and date_start have been successfully validated separately.

Line 1391: from per_all_people_f p,

1387: and pds.date_start = p_date_start;
1388: --
1389: cursor csr_valid_pers_date is
1390: select null
1391: from per_all_people_f p,
1392: per_person_types pt
1393: where p.person_id = p_person_id
1394: and p.effective_start_date = p_date_start
1395: and pt.person_type_id = p.person_type_id

Line 1450: -- on PER_ALL_PEOPLE_F for system_person_type of 'EMP' or 'EMP_APL'.

1446: --
1447: hr_utility.set_location(l_proc, 7);
1448: --
1449: -- Check that the Person ID and Date Start combination exists
1450: -- on PER_ALL_PEOPLE_F for system_person_type of 'EMP' or 'EMP_APL'.
1451: --
1452: open csr_valid_pers_date;
1453: --
1454: fetch csr_valid_pers_date into l_exists;

Line 1573: -- a) Must exist in PER_ALL_PEOPLE_F for the ACCEPTED_TERMINATION_DATE

1569: -- ---------------------------------------------------------------------------
1570: --
1571: -- Description:
1572: -- Validates that the following business rules are met:
1573: -- a) Must exist in PER_ALL_PEOPLE_F for the ACCEPTED_TERMINATION_DATE
1574: -- (U)
1575: -- b) Must not be the same as PERSON_ID (I,U)
1576: -- c) Must be null (I)
1577: --

Line 1612: -- Desciption : Changed the subquery table from per_people_f to per_all_people_f

1608: l_proc varchar2(72) := g_package||'chk_termination_accepted_pers';
1609: --
1610: --
1611: --Bug# 2810608 Start here
1612: -- Desciption : Changed the subquery table from per_people_f to per_all_people_f
1613: -- so that the termination accepted by person is validated from all employees
1614: --
1615: cursor csr_valid_term_person is
1616: select null

Line 1617: from per_all_people_f per

1613: -- so that the termination accepted by person is validated from all employees
1614: --
1615: cursor csr_valid_term_person is
1616: select null
1617: from per_all_people_f per
1618: where per.person_id = p_termination_accepted_person
1619: and nvl(p_accepted_termination_date, p_effective_date) >=
1620: (select min(per2.effective_start_date)
1621: from per_all_people_f per2

Line 1621: from per_all_people_f per2

1617: from per_all_people_f per
1618: where per.person_id = p_termination_accepted_person
1619: and nvl(p_accepted_termination_date, p_effective_date) >=
1620: (select min(per2.effective_start_date)
1621: from per_all_people_f per2
1622: where per2.person_id = per.person_id)
1623: and nvl(p_accepted_termination_date, p_effective_date) <=
1624: (select max(per3.effective_end_date)
1625: from per_all_people_f per3

Line 1625: from per_all_people_f per3

1621: from per_all_people_f per2
1622: where per2.person_id = per.person_id)
1623: and nvl(p_accepted_termination_date, p_effective_date) <=
1624: (select max(per3.effective_end_date)
1625: from per_all_people_f per3
1626: where per3.person_id = per.person_id);
1627: --
1628: -- Bug# 2810608 End here
1629: --