APPS.PAY_US_MMREF_REPORTING1 dependencies on PER_ALL_ASSIGNMENTS_F

Line 823: FROM per_all_assignments_f paf,

819: */
820: IF p_report_type = 'FEDW2' THEN
821: p_sqlstr := '
822: SELECT DISTINCT paf.person_id
823: FROM per_all_assignments_f paf,
824: pay_assignment_actions paa,
825: pay_payroll_actions ppa,
826: pay_payroll_actions ppa1
827: WHERE ppa1.payroll_action_id = :payroll_action_id

Line 857: per_all_assignments_f paf,

853: ff_archive_items fai,
854: ff_database_items fdi,
855: pay_assignment_actions paa,
856: pay_payroll_actions ppa,
857: per_all_assignments_f paf,
858: pay_payroll_actions ppa1
859: WHERE
860: ppa1.payroll_action_id = :payroll_action_id
861: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 945: per_all_assignments_f paf,

941: ff_archive_items fai,
942: ff_database_items fdi,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa,
945: per_all_assignments_f paf,
946: pay_payroll_actions ppa1
947: WHERE
948: ppa1.payroll_action_id = p_pactid
949: and ppa.business_group_id+0 = ppa1.business_group_id

Line 1009: per_all_assignments_f paf,

1005: ff_archive_items fai,
1006: ff_database_items fdi,
1007: pay_assignment_actions paa,
1008: pay_payroll_actions ppa,
1009: per_all_assignments_f paf,
1010: pay_payroll_actions ppa1
1011: WHERE
1012: ppa1.payroll_action_id = p_pactid
1013: and ppa.business_group_id+0 = ppa1.business_group_id

Line 1058: per_all_assignments_f paf,

1054: paf.effective_end_date,
1055: paa.assignment_action_id
1056: FROM pay_payroll_actions ppa,
1057: pay_assignment_actions paa,
1058: per_all_assignments_f paf,
1059: pay_payroll_actions ppa1
1060: WHERE ppa1.payroll_action_id = p_pactid
1061: AND ppa.report_type = 'YREND'
1062: AND ppa.business_group_id+0 = ppa1.business_group_id