APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_ALL_PAYROLLS_F

Line 214: pay_all_payrolls_f pay,

210: l_check number;
211: cursor csr_check_asg is
212: select 1
213: from per_all_assignments_f asg,
214: pay_all_payrolls_f pay,
215: hr_soft_coding_keyflex flex
216: where asg.assignment_id = p_assignment_id
217: and asg.payroll_id = pay.payroll_id
218: and pay.soft_coding_keyflex_id + 0 = flex.soft_coding_keyflex_id

Line 534: pay_all_payrolls_f ppf

530: /* cursor csr_flex_id is
531: select distinct flex.soft_coding_keyflex_id flex_id
532: from hr_soft_coding_keyflex flex,
533: --bug 6278134 added join conditions with ppf
534: pay_all_payrolls_f ppf
535: where flex.segment1 = nvl(l_tax_reference,flex.segment1)
536: AND ppf.soft_coding_keyflex_id + 0 = flex.soft_coding_keyflex_id
537: and ppf.payroll_id = nvl(l_payroll_id,ppf.payroll_id)
538: -- bug 7122883 added join condition with business_group_id

Line 571: pay_all_payrolls_f ppf,

567: pet.element_type_id element_type_id,
568: peev.element_entry_id element_entry_id,
569: peev.effective_start_date effective_start_date
570: from per_all_assignments_f paa,
571: pay_all_payrolls_f ppf,
572: pay_element_classifications pec,
573: pay_element_types_f pet,
574: pay_input_values_f piv,
575: pay_element_entries_f pee,

Line 639: pay_all_payrolls_f ppf,

635: pet.element_type_id element_type_id,
636: peev.element_entry_id element_entry_id,
637: peev.effective_start_date effective_start_date
638: from per_all_assignments_f paa,
639: pay_all_payrolls_f ppf,
640: pay_element_classifications pec,
641: pay_element_types_f pet,
642: pay_input_values_f piv,
643: pay_element_entries_f pee,

Line 697: pay_all_payrolls_f ppf,

693: pet.element_type_id element_type_id,
694: peev.element_entry_id element_entry_id,
695: peev.effective_start_date effective_start_date
696: from per_all_assignments_f paa,
697: pay_all_payrolls_f ppf,
698: pay_element_classifications pec,
699: pay_element_types_f pet,
700: pay_input_values_f piv,
701: pay_element_entries_f pee,

Line 1000: pay_all_payrolls_f pay,

996: pap.date_of_birth
997: FROM per_all_assignments_f paa,
998: per_all_people_f pap,
999: per_periods_of_service pps,
1000: pay_all_payrolls_f pay,
1001: hr_soft_coding_keyflex flex
1002: WHERE paa.person_id = pap.person_id
1003: AND pps.PERIOD_OF_SERVICE_ID(+) = paa.PERIOD_OF_SERVICE_ID
1004: AND least(nvl(pps.ACTUAL_TERMINATION_DATE,fnd_date.canonical_to_date(g_param_benefit_end_date)),