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: --
139: begin
140: hr_utility.set_location('Entering:'|| l_proc, 1);

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

1325: -- Description:
1326: -- Validates that the following business rules are met:
1327: -- a) PERSON_ID and DATE_START combination must be unique (I)
1328: -- b) PERSON_ID and DATE_START combination must exist in
1329: -- PER_ALL_PEOPLE_F where PERSON_SYSTEM_TYPE in ('EMP', 'EMP_APL')
1330: -- (I,U)
1331: --
1332: -- Pre-conditions:
1333: -- person_id and date_start have been successfully validated separately.

Line 1370: from per_all_people_f p,

1366: and pds.date_start = p_date_start;
1367: --
1368: cursor csr_valid_pers_date is
1369: select null
1370: from per_all_people_f p,
1371: per_person_types pt
1372: where p.person_id = p_person_id
1373: and p.effective_start_date = p_date_start
1374: and pt.person_type_id = p.person_type_id

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

1425: --
1426: hr_utility.set_location(l_proc, 7);
1427: --
1428: -- Check that the Person ID and Date Start combination exists
1429: -- on PER_ALL_PEOPLE_F for system_person_type of 'EMP' or 'EMP_APL'.
1430: --
1431: open csr_valid_pers_date;
1432: --
1433: fetch csr_valid_pers_date into l_exists;

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

1548: -- ---------------------------------------------------------------------------
1549: --
1550: -- Description:
1551: -- Validates that the following business rules are met:
1552: -- a) Must exist in PER_ALL_PEOPLE_F for the ACCEPTED_TERMINATION_DATE
1553: -- (U)
1554: -- b) Must not be the same as PERSON_ID (I,U)
1555: -- c) Must be null (I)
1556: --

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

1587: l_proc varchar2(72) := g_package||'chk_termination_accepted_pers';
1588: --
1589: --
1590: --Bug# 2810608 Start here
1591: -- Desciption : Changed the subquery table from per_people_f to per_all_people_f
1592: -- so that the termination accepted by person is validated from all employees
1593: --
1594: cursor csr_valid_term_person is
1595: select null

Line 1596: from per_all_people_f per

1592: -- so that the termination accepted by person is validated from all employees
1593: --
1594: cursor csr_valid_term_person is
1595: select null
1596: from per_all_people_f per
1597: where per.person_id = p_termination_accepted_person
1598: and nvl(p_accepted_termination_date, p_effective_date) >=
1599: (select min(per2.effective_start_date)
1600: from per_all_people_f per2

Line 1600: from per_all_people_f per2

1596: from per_all_people_f per
1597: where per.person_id = p_termination_accepted_person
1598: and nvl(p_accepted_termination_date, p_effective_date) >=
1599: (select min(per2.effective_start_date)
1600: from per_all_people_f per2
1601: where per2.person_id = per.person_id)
1602: and nvl(p_accepted_termination_date, p_effective_date) <=
1603: (select max(per3.effective_end_date)
1604: from per_all_people_f per3

Line 1604: from per_all_people_f per3

1600: from per_all_people_f per2
1601: where per2.person_id = per.person_id)
1602: and nvl(p_accepted_termination_date, p_effective_date) <=
1603: (select max(per3.effective_end_date)
1604: from per_all_people_f per3
1605: where per3.person_id = per.person_id);
1606: --
1607: -- Bug# 2810608 End here
1608: --