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 970: pay_assignment_actions paa

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

Line 1238: select pay_assignment_actions_s.nextval

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

Line 1252: from pay_assignment_actions paa,

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