APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 213: from per_all_assignments_f asg,

209: l_ret boolean;
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

Line 570: from per_all_assignments_f paa,

566: pet.element_name element_name,
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,

Line 638: from per_all_assignments_f paa,

634: pet.element_name element_name,
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,

Line 696: from per_all_assignments_f paa,

692: pet.element_name element_name,
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,

Line 997: FROM per_all_assignments_f paa,

993: pap.person_id,
994: pap.national_identifier,
995: pap.sex,
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

Line 1153: from per_all_assignments_f

1149:
1150: cursor csr_get_asg_end_date(p_assignment_id number)
1151: is
1152: select max(effective_end_date)
1153: from per_all_assignments_f
1154: where assignment_id = p_assignment_id;
1155:
1156: l_element_name pay_element_types_f.element_name%TYPE;
1157: l_formula_id ff_formulas_f.formula_id%TYPE;

Line 1819: per_all_assignments_f paaf

1815:
1816: cursor c_get_per_det is
1817: select paa.payroll_action_id, paaf.person_id
1818: from pay_assignment_actions paa,
1819: per_all_assignments_f paaf
1820: where paa.assignment_action_id = p_ass_act_id
1821: and paa.assignment_id = paaf.assignment_id;
1822:
1823: cursor c_get_updated_status (c_person_id in number,

Line 1830: per_all_assignments_f paaf

1826: from dual
1827: where exists (select 'X'
1828: from pay_action_information pai,
1829: pay_assignment_actions paa,
1830: per_all_assignments_f paaf
1831: where paaf.person_id = c_person_id
1832: and paaf.assignment_id = paa.assignment_id
1833: and paa.payroll_action_id = c_payroll_action_id
1834: and paa.assignment_action_id = pai.action_context_id

Line 2765: from per_all_assignments_f a,

2761: select p1.full_name,
2762: p1.first_name,
2763: p1.last_name,
2764: p1.middle_names
2765: from per_all_assignments_f a,
2766: per_all_people_f p,
2767: per_all_people_f p1
2768: where a.assignment_id = p_assignment_id
2769: and p.person_id = a.person_id

Line 2791: per_all_assignments_f per

2787: a1.postal_code,
2788: a1.country
2789: from pay_action_information a,
2790: per_addresses a1,
2791: per_all_assignments_f per
2792: where per.assignment_id = p_assignment_id
2793: and p_asg_end_date between per.effective_start_date and per.effective_end_date
2794: and a1.person_id = per.person_id
2795: /*

Line 4332: per_all_assignments_f paf,

4328: substr(pml.line_text,6,instr(pml.line_text,':') - 6) element_name,
4329: pml.line_sequence
4330: from pay_payroll_actions pay,
4331: pay_assignment_actions paa,
4332: per_all_assignments_f paf,
4333: per_all_people_f pap,
4334: per_periods_of_service pos,
4335: pay_message_lines pml
4336: where pay.payroll_action_id = p_pact_id