DBA Data[Home] [Help]

APPS.SSP_PAB_PKG dependencies on PER_ALL_PEOPLE_F

Line 41: to per_all_people_f and per_all_assignments_f

37: 18 Oct 05 4670360 KThampan Amended parameter's order of function
38: LATEST_PPP_START_DATE
39: 09 Feb 06 4891953 Kthampan Fixed performance bug.
40: 23 Aug 06 5482199 KThampan Change from per_people_f and per_assignments_f
41: to per_all_people_f and per_all_assignments_f
42: 19 Spe 06 5547703 KThampan Amend pab_control to call generate_payments
43: with insert-mode if absence is > 0 and
44: also change csr_check_if_existing_entries
45: not to reference from per_absence_attendances

Line 92: per_all_people_f PERSON,

88: person.date_of_death,
89: service.date_start,
90: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
91: from ssp_maternities MATERNITY,
92: per_all_people_f PERSON,
93: per_periods_of_service SERVICE
94: where person.person_id = maternity.person_id
95: and person.person_id = service.person_id
96: and maternity.maternity_id = p_maternity_id

Line 693: from per_all_people_f ppf

689: l_proc varchar2 (72) := g_package||'check_death';
690: --
691: cursor csr_check_death is
692: select ppf.date_of_death
693: from per_all_people_f ppf
694: where ppf.person_id = person.person_id
695: and ppf.date_of_death is not null;
696: --
697: l_death_date date;