APPS.SSP_ERN_BUS dependencies on PAY_ALL_PAYROLLS_F

Line 241: from pay_all_payrolls_f papf,

237: select max(ptp.end_date)
238: from per_time_periods ptp
239: where ptp.payroll_id in
240: ( select papf.payroll_id
241: from pay_all_payrolls_f papf,
242: per_all_assignments_f paf,
243: per_all_people_f ppf,
244: per_time_periods ptp
245: where ppf.person_id = paf.person_id

Line 278: from pay_all_payrolls_f papf,

274: select max(ptp.end_date)
275: from per_time_periods ptp
276: where ptp.payroll_id in
277: ( select papf.payroll_id
278: from pay_all_payrolls_f papf,
279: per_all_assignments_f paf,
280: per_all_people_f ppf,
281: per_time_periods ptp
282: where ppf.person_id = paf.person_id

Line 308: from pay_all_payrolls_f ppf

304: -- l_end_of_relevant_period.
305: --
306: cursor csr_get_payroll_id_start is
307: select ppf.payroll_id
308: from pay_all_payrolls_f ppf
309: , per_all_assignments_f paf
310: where ppf.payroll_id = paf.payroll_id
311: and paf.assignment_id = l_assignment_id
312: and l_start_of_relevant_period between

Line 452: from pay_all_payrolls_f PAYROLL,

448: -- that the person is on as of the p_effective_date which is the
449: -- PIW_start_date(SSP) or QW_start_date(SMP).
450: --
451: select period_type.number_per_fiscal_year fiscal_year
452: from pay_all_payrolls_f PAYROLL,
453: per_all_assignments_f ASSIGNMENT,
454: per_time_period_types PERIOD_TYPE
455: where assignment.assignment_id = l_assignment_id
456: and assignment.effective_start_date <= l_end_of_relevant_period

Line 748: from pay_all_payrolls_f PAYROLL,

744: -- _days to return a fiscal_year value of 12 (i.e. Monthly).
745: --
746: cursor csr_number_of_days is
747: select period_type.number_per_fiscal_year fiscal_year
748: from pay_all_payrolls_f PAYROLL,
749: per_all_assignments_f ASSIGNMENT,
750: per_time_period_types PERIOD_TYPE
751: where assignment.assignment_id = l_assignment_id
752: and payroll.payroll_id = assignment.payroll_id