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 479: from pay_all_payrolls_f PAYROLL,

475: -- that the person is on as of the p_effective_date which is the
476: -- PIW_start_date(SSP) or QW_start_date(SMP).
477: --
478: select period_type.number_per_fiscal_year fiscal_year
479: from pay_all_payrolls_f PAYROLL,
480: per_all_assignments_f ASSIGNMENT,
481: per_time_period_types PERIOD_TYPE
482: where assignment.assignment_id = l_assignment_id
483: and assignment.effective_start_date <= l_end_of_relevant_period

Line 775: from pay_all_payrolls_f PAYROLL,

771: -- _days to return a fiscal_year value of 12 (i.e. Monthly).
772: --
773: cursor csr_number_of_days is
774: select period_type.number_per_fiscal_year fiscal_year
775: from pay_all_payrolls_f PAYROLL,
776: per_all_assignments_f ASSIGNMENT,
777: per_time_period_types PERIOD_TYPE
778: where assignment.assignment_id = l_assignment_id
779: and payroll.payroll_id = assignment.payroll_id