APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PER_ASSIGNMENTS_F

Line 225: from per_assignments_f paa2

221: flex.segment1 = p_tax_ref)
222: and (fnd_date.canonical_to_date(p_end_date) between asg.effective_start_date and asg.effective_end_date
223: or
224: ( asg.effective_end_date = (select max(paa2.effective_end_date)
225: from per_assignments_f paa2
226: where paa2.assignment_id = p_assignment_id)
227: and asg.effective_end_date < fnd_date.canonical_to_date(p_end_date)));
228: BEGIN
229: l_ret := false;

Line 685: select /*+ ORDERED INDEX(paa PER_ASSIGNMENTS_F_N12,

681: and hasa.include_or_exclude = 'E')
682: order by paa.assignment_id;
683:
684: cursor csr_noassign_set is
685: select /*+ ORDERED INDEX(paa PER_ASSIGNMENTS_F_N12,
686: ppf PAY_PAYROLLS_F_PK)
687: USE_NL(paa,ppf,pec,pet,piv,pee,peev) */
688: distinct
689: paa.assignment_id,

Line 1019: from per_assignments_f paa2

1015: AND (fnd_date.canonical_to_date(g_param_benefit_end_date) between paa.effective_start_date AND paa.effective_end_date
1016: OR
1017: (
1018: paa.effective_end_date = (select max(paa2.effective_end_date)
1019: from per_assignments_f paa2
1020: where paa2.assignment_id = p_assignment_id)
1021: and paa.effective_end_date < fnd_date.canonical_to_date(g_param_benefit_end_date))
1022: );
1023:

Line 1055: per_assignments_f paa,

1051: pay_element_classifications pec,
1052: pay_input_values_f piv,
1053: pay_element_entry_values_f peev,
1054: pay_element_entries_f pee,
1055: per_assignments_f paa,
1056: pay_assignment_actions paac
1057: WHERE pet.classification_id = pec.classification_id AND
1058: pet.element_type_id = piv.element_type_id AND
1059: piv.input_value_id = peev.input_value_id AND

Line 1146: per_assignments_f paf

1142: cursor csr_get_term_date (p_assignment_id Number)
1143: is
1144: select ACTUAL_TERMINATION_DATE
1145: from per_periods_of_service pps,
1146: per_assignments_f paf
1147: where paf.PERIOD_OF_SERVICE_ID = pps.PERIOD_OF_SERVICE_ID
1148: and paf.assignment_id =p_assignment_id;
1149:
1150: cursor csr_get_asg_end_date(p_assignment_id number)

Line 2655: from per_assignments_f paf,

2651: l_nat_number VARCHAR2(100);
2652:
2653: cursor csr_ni is
2654: select ppf.national_identifier
2655: from per_assignments_f paf,
2656: per_all_people_f ppf,
2657: per_periods_of_service pps
2658: where ppf.person_id = paf.person_id
2659: and paf.assignment_id = p_assid