APPS.PAY_US_1099R_MAG_REPORTING dependencies on PAY_ASSIGNMENT_ACTIONS

Line 522: from pay_assignment_actions paa

518: select '1'
519: from dual
520: where exists (
521: select '1'
522: from pay_assignment_actions paa
523: where paa.payroll_action_id = cp_payroll_action_id
524: and paa.action_status = decode(cp_status_type,'R','M', --If R is passed we compare for retry
525: cp_status_type))
526: and not exists (

Line 838: pay_assignment_actions paa,

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
842: and ppa.report_type = ''YREND''

Line 971: pay_assignment_actions paa

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
975: and pww.tax_unit_id = paa.tax_unit_id

Line 1240: select pay_assignment_actions_s.nextval

1236: end if;
1237:
1238: if ln_create_assignment = 1 then
1239:
1240: select pay_assignment_actions_s.nextval
1241: into ln_lockingactid from dual;
1242:
1243: hr_utility.set_location(
1244: 'pay_us_1099r_mag_reporting.mag_1099r_action_creation', 60);

Line 1254: from pay_assignment_actions paa,

1250: 'pay_us_1099r_mag_reporting.mag_1099r_action_creation', 70);
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