APPS.SSP_ERN_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 175: from per_all_assignments_f ASG

171: -- incorrectly.
172: --
173: select distinct
174: asg.assignment_id
175: from per_all_assignments_f ASG
176: where asg.period_of_service_id = L_PERIOD_OF_SERVICE_ID
177: and asg.payroll_id is not null
178: --6791913 begin - To treat adoption in the same way as Maternity
179: --and (( p_absence_category = 'M'

Line 242: per_all_assignments_f paf,

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
246: and papf.payroll_id = paf.payroll_id

Line 279: per_all_assignments_f paf,

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
283: and papf.payroll_id = paf.payroll_id

Line 309: , per_all_assignments_f paf

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
313: paf.effective_start_date and paf.effective_end_date;

Line 321: from per_all_assignments_f paf

317: -- of the last eight weeks for calculating average earnings.
318: --
319: cursor csr_get_payroll_id_end is
320: select payroll_id
321: from per_all_assignments_f paf
322: where paf.assignment_id = L_ASSIGNMENT_ID
323: and P_EFFECTIVE_DATE between
324: paf.effective_start_date and paf.effective_end_date;
325:

Line 330: from per_all_assignments_f

326: --
327: --
328: cursor csr_chk_asg is
329: select 1
330: from per_all_assignments_f
331: where assignment_id = L_ASSIGNMENT_ID
332: and l_start_of_relevant_period between effective_start_date and effective_end_date;
333:
334: cursor csr_get_start_date is

Line 336: from per_all_assignments_f

332: and l_start_of_relevant_period between effective_start_date and effective_end_date;
333:
334: cursor csr_get_start_date is
335: select min(effective_start_date)
336: from per_all_assignments_f
337: where assignment_id = L_ASSIGNMENT_ID;
338: --
339: --
340: begin

Line 453: per_all_assignments_f ASSIGNMENT,

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
457: and assignment.effective_end_date >= l_start_of_relevant_period

Line 711: from per_all_assignments_f paf

707: -- actual number of payment periods.
708: --
709: cursor csr_get_number_of_reg_payments is
710: select peev.screen_entry_value
711: from per_all_assignments_f paf
712: , pay_element_entry_values_f peev
713: , pay_element_entries_f pee
714: , pay_element_types_f pet
715: , pay_element_links_f pel

Line 749: per_all_assignments_f ASSIGNMENT,

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
753: and payroll.period_type = period_type.period_type