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 969: per_all_assignments_f paf,

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

Line 1030: from per_all_assignments_f paf,

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

Line 1253: per_all_assignments_f paf,

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