DBA Data[Home] [Help]

APPS.PAY_MX_SUA_MAG dependencies on PER_ALL_ASSIGNMENTS_F

Line 412: per_all_assignments_f paf,

408: paf.person_id,
409: ppa_arch.payroll_action_id
410: FROM pay_assignment_actions paa_arch,
411: pay_payroll_actions ppa_arch,
412: per_all_assignments_f paf,
413: pay_action_information pai
414: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
415: AND paa_arch.assignment_id = paf.assignment_id
416: -- Bug 4518777

Line 482: per_all_assignments_f paf,

478: paf.person_id,
479: ppa_arch.payroll_action_id
480: FROM pay_assignment_actions paa_arch,
481: pay_payroll_actions ppa_arch,
482: per_all_assignments_f paf,
483: pay_population_ranges ppr,
484: pay_action_information pai
485: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
486: AND paa_arch.assignment_id = paf.assignment_id

Line 783: per_all_assignments_f paf,

779: pai.action_information_id,
780: nvl(pai.action_information21, 'N') -- Do not report flag
781: FROM pay_action_information pai,
782: pay_assignment_actions paa_arch,
783: per_all_assignments_f paf,
784: pay_action_interlocks lck
785: WHERE pai.action_context_id = paa_arch.assignment_action_id
786: AND paf.assignment_id = paa_arch.assignment_id
787: /*Bug 8768679*/

Line 814: per_all_assignments_f paf,

810: pai.action_information2, -- transaction date
811: pai.action_information24 -- Report Rehire Termination
812: FROM pay_action_information pai,
813: pay_assignment_actions paa_arch,
814: per_all_assignments_f paf,
815: pay_action_interlocks lck
816: WHERE pai.action_context_id = paa_arch.assignment_action_id
817: AND paf.assignment_id = paa_arch.assignment_id
818: --Bug 7185703

Line 1050: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')

1046: FROM pay_process_events ppe
1047: WHERE EXISTS
1048: (SELECT 1
1049: FROM pay_event_updates peu
1050: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')
1051: AND ppe.event_update_id = peu.event_update_id
1052: );
1053:
1054: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN