APPS.PAY_US_MAGW2_REPORTING dependencies on PER_ASSIGNMENTS_F

Line 213: FROM per_assignments_f paf

209: CURSOR c_gre_state (cp_tax_unit_id NUMBER)IS
210: SELECT paf.person_id,
211: paf.assignment_id,
212: paf.effective_end_date
213: FROM per_assignments_f paf
214: WHERE exists
215: (SELECT 'x'
216: FROM pay_us_emp_state_tax_rules_f pest
217: WHERE pest.state_code = p_state_code

Line 248: FROM per_assignments_f paf

244: CURSOR c_gre_fed (cp_tax_unit_id NUMBER) IS
245: SELECT paf.person_id,
246: paf.assignment_id,
247: paf.effective_end_date
248: FROM per_assignments_f paf
249: WHERE paf.business_group_id+0 = p_business_group_id
250: -- In order to avoid full table scan on per_assignment_f
251: -- added assignmet_id
252: AND paf.assignment_id >= 0

Line 806: FROM per_assignments_f paf,

802: ) THEN
803: IF p_report_type = 'FEDW2' THEN
804: p_sqlstr := '
805: SELECT DISTINCT paf.person_id
806: FROM per_assignments_f paf,
807: pay_assignment_actions paa,
808: pay_payroll_actions ppa,
809: pay_payroll_actions ppa1
810: WHERE ppa1.payroll_action_id = :payroll_action_id

Line 840: per_assignments_f paf,

836: ff_archive_items fai,
837: ff_database_items fdi,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa,
840: per_assignments_f paf,
841: pay_payroll_actions ppa1
842: WHERE
843: ppa1.payroll_action_id = :payroll_action_id
844: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 927: per_assignments_f paf,

923: ff_archive_items fai,
924: ff_database_items fdi,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,
927: per_assignments_f paf,
928: pay_payroll_actions ppa1
929: WHERE
930: ppa1.payroll_action_id = p_pactid
931: and ppa.business_group_id+0 = ppa1.business_group_id

Line 977: per_assignments_f paf,

973: paa.assignment_action_id
974: FROM pay_payroll_actions ppa,
975: pay_assignment_actions paa,
976: --hr_soft_coding_keyflex hsck,
977: per_assignments_f paf,
978: pay_payroll_actions ppa1
979: WHERE ppa1.payroll_action_id = p_pactid
980: AND ppa.report_type = 'YREND'
981: AND ppa.business_group_id+0 = ppa1.business_group_id