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 1018: from per_assignments_f paa2

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

Line 1054: per_assignments_f paa,

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

Line 1145: per_assignments_f paf

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

Line 2589: from per_assignments_f paf,

2585: l_nat_number VARCHAR2(100);
2586:
2587: cursor csr_ni is
2588: select ppf.national_identifier
2589: from per_assignments_f paf,
2590: per_all_people_f ppf,
2591: per_periods_of_service pps
2592: where ppf.person_id = paf.person_id
2593: and paf.assignment_id = p_assid