APPS.PAY_GB_DEO dependencies on PER_ALL_ASSIGNMENTS_F

Line 129: per_all_assignments_f paa,

125: substr(trim(pap.first_name), 1,least(decode(instr(trim(pap.first_name),' '),0,35,instr(trim(pap.first_name),' ')),35)) first_name,
126: substr(pap.national_identifier,1,9) national_identifier,
127: pap.effective_start_date effective_start_date
128: FROM pay_assignment_actions act,
129: per_all_assignments_f paa,
130: per_all_people_f pap
131: where act.assignment_action_id = p_assactid
132: and act.assignment_id = paa.assignment_id
133: and paa.person_id = pap.person_id

Line 324: per_all_assignments_f paaf,

320: from pay_element_types_f pet,
321: pay_input_values_f piv,
322: pay_element_entry_values_f peev,
323: pay_element_entries_f peef,
324: per_all_assignments_f paaf,
325: hr_soft_coding_keyflex sc,
326: pay_all_payrolls_f ppf,
327: pay_assignment_actions paa,
328: pay_payroll_actions ppa

Line 363: from per_all_assignments_f paaf1 where

359: AND ppa.EFFECTIVE_DATE between piv.effective_start_date AND piv.effective_end_date
360: AND ppa.EFFECTIVE_DATE between ppf.effective_start_date AND ppf.effective_end_date
361: AND paaf.effective_start_date =
362: (select max(paaf1.effective_start_date)
363: from per_all_assignments_f paaf1 where
364: paaf1.assignment_id = paaf.assignment_id
365: and paaf1.assignment_type = 'E'
366: and paaf1.effective_start_date <= ppa.EFFECTIVE_DATE)
367: group by paaf.person_id;

Line 479: per_all_assignments_f paaf,

475: pay_input_values_f piv2,
476: pay_element_entry_values_f peev1,
477: pay_element_entry_values_f peev2,
478: pay_element_entries_f peef,
479: per_all_assignments_f paaf,
480: hr_soft_coding_keyflex scl,
481: pay_all_payrolls_f ppf,
482: pay_assignment_actions paa,
483: pay_payroll_actions ppa

Line 527: from per_all_assignments_f paaf1 where

523: AND ppa.EFFECTIVE_DATE between piv2.effective_start_date AND piv2.effective_end_date
524: AND ppa.EFFECTIVE_DATE between ppf.effective_start_date AND ppf.effective_end_date
525: AND paaf.effective_start_date =
526: (select max(paaf1.effective_start_date)
527: from per_all_assignments_f paaf1 where
528: paaf1.assignment_id = paaf.assignment_id
529: and paaf1.assignment_type = 'E'
530: and paaf1.effective_start_date <= ppa.EFFECTIVE_DATE)
531: group by paaf.person_id,peev2.screen_entry_value;

Line 550: per_all_assignments_f paaf,

546: from pay_element_types_f pet,
547: pay_input_values_f piv,
548: pay_element_entry_values_f peev,
549: pay_element_entries_f peef,
550: per_all_assignments_f paaf,
551: hr_soft_coding_keyflex sc,
552: pay_all_payrolls_f ppf,
553: pay_assignment_actions paa,
554: pay_payroll_actions ppa

Line 590: from per_all_assignments_f paaf1 where

586: AND ppa.EFFECTIVE_DATE between piv.effective_start_date AND piv.effective_end_date
587: AND ppa.EFFECTIVE_DATE between ppf.effective_start_date AND ppf.effective_end_date
588: AND paaf.effective_start_date =
589: (select max(paaf1.effective_start_date)
590: from per_all_assignments_f paaf1 where
591: paaf1.assignment_id = paaf.assignment_id
592: and paaf1.assignment_type = 'E'
593: and paaf1.effective_start_date <= ppa.EFFECTIVE_DATE)
594: order by peef.assignment_id,paa.assignment_action_id;

Line 951: , per_all_assignments_f paaf

947: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
948: , paaf.assignment_number
949: from pay_payroll_actions ppa,
950: pay_assignment_actions paa
951: , per_all_assignments_f paaf
952: where ppa.payroll_action_id = pactid -- pact_id
953: and paa.payroll_action_id = ppa.payroll_action_id
954: and paa.action_status = 'C'
955: and paaf.assignment_id = paa.assignment_id

Line 959: FROM per_all_assignments_f paaf2

955: and paaf.assignment_id = paa.assignment_id
956: and paaf.effective_start_date =
957: (
958: SELECT MAX(paaf2.effective_start_date)
959: FROM per_all_assignments_f paaf2
960: WHERE paaf2.assignment_id = paaf.assignment_id
961: )
962: ORDER BY
963: paaf.assignment_number;

Line 1017: per_all_assignments_f paaf

1013: cursor get_person_count is
1014: select count(distinct(paaf.person_id))
1015: from pay_payroll_actions ppa,
1016: pay_assignment_actions paa,
1017: per_all_assignments_f paaf
1018: where ppa.payroll_action_id = pactid -- pact_id
1019: and paa.payroll_action_id = ppa.payroll_action_id
1020: and paa.action_status = 'C'
1021: and paaf.assignment_id = paa.assignment_id;