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 695: from per_all_assignments_f paa,

691: pet.element_name element_name,
692: pet.element_type_id element_type_id,
693: peev.element_entry_id element_entry_id,
694: peev.effective_start_date effective_start_date
695: from per_all_assignments_f paa,
696: pay_all_payrolls_f ppf,
697: pay_element_classifications pec,
698: pay_element_types_f pet,
699: pay_input_values_f piv,

Line 996: FROM per_all_assignments_f paa,

992: pap.person_id,
993: pap.national_identifier,
994: pap.sex,
995: pap.date_of_birth
996: FROM per_all_assignments_f paa,
997: per_all_people_f pap,
998: per_periods_of_service pps,
999: pay_all_payrolls_f pay,
1000: hr_soft_coding_keyflex flex

Line 1152: from per_all_assignments_f

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

Line 2699: from per_all_assignments_f a,

2695: select p1.full_name,
2696: p1.first_name,
2697: p1.last_name,
2698: p1.middle_names
2699: from per_all_assignments_f a,
2700: per_all_people_f p,
2701: per_all_people_f p1
2702: where a.assignment_id = p_assignment_id
2703: and p.person_id = a.person_id

Line 2725: per_all_assignments_f per

2721: a1.postal_code,
2722: a1.country
2723: from pay_action_information a,
2724: per_addresses a1,
2725: per_all_assignments_f per
2726: where per.assignment_id = p_assignment_id
2727: and p_asg_end_date between per.effective_start_date and per.effective_end_date
2728: and a1.person_id = per.person_id
2729: /*

Line 4212: per_all_assignments_f paf,

4208: substr(pml.line_text,6,instr(pml.line_text,':') - 6) element_name,
4209: pml.line_sequence
4210: from pay_payroll_actions pay,
4211: pay_assignment_actions paa,
4212: per_all_assignments_f paf,
4213: per_all_people_f pap,
4214: per_periods_of_service pos,
4215: pay_message_lines pml
4216: where pay.payroll_action_id = p_pact_id