APPS.PAY_US_1099R_MAG_REPORTING dependencies on PER_ALL_ASSIGNMENTS_F

Line 837: per_all_assignments_f paf,

833:
834: lv_sql_string :=
835: 'select distinct paf.person_id
836: from --hr_soft_coding_keyflex hsck,
837: per_all_assignments_f paf,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa1,
840: pay_payroll_actions ppa
841: where ppa1.payroll_action_id = :p_payroll_action_id

Line 872: per_all_assignments_f paf,

868: lv_sql_string :=
869: 'select distinct paf.person_id
870: from --hr_soft_coding_keyflex hsck,
871: hr_organization_units hou,
872: per_all_assignments_f paf,
873: pay_us_state_w2_v psv,
874: pay_payroll_actions ppa
875: where ppa.payroll_action_id = :p_payroll_action_id
876: and hou.business_group_id + 0 = ppa.business_group_id + 0

Line 970: per_all_assignments_f paf,

966: pww.gross_1099r
967: from pay_payroll_actions ppa,
968: pay_payroll_actions ppa1,
969: pay_us_wages_1099r_v pww,
970: per_all_assignments_f paf,
971: pay_assignment_actions paa
972: where ppa1.payroll_action_id = cp_payroll_action_id
973: and pww.year = to_number(to_char(ppa.effective_date, 'YYYY'))
974: and pww.assignment_id = paf.assignment_id

Line 1031: from per_all_assignments_f paf,

1027: paf.effective_end_date,
1028: paf.assignment_id,
1029: psv.w2_state_wages,
1030: psv.w2_state_income_tax
1031: from per_all_assignments_f paf,
1032: pay_us_state_w2_v psv,
1033: pay_payroll_actions ppa
1034: where ppa.payroll_action_id = cp_payroll_action_id
1035: and psv.year = to_number(to_char(ppa.effective_date, 'YYYY'))

Line 1255: per_all_assignments_f paf,

1251:
1252: --Create Interlock
1253: select assignment_action_id into ln_lockedactid
1254: from pay_assignment_actions paa,
1255: per_all_assignments_f paf,
1256: pay_payroll_actions ppa
1257: where paa.payroll_action_id = ppa.payroll_action_id
1258: and paa.assignment_id = paf.assignment_id
1259: and paa.tax_unit_id = ln_tax_unit_id