APPS.PAY_US_MMREF_REPORTING_MT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 266: FROM pay_assignment_actions paa

262: CURSOR c_arch_errored_asg (cp_payroll_action_id NUMBER) IS
263: SELECT '1'
264: FROM dual
265: WHERE EXISTS (SELECT '1'
266: FROM pay_assignment_actions paa
267: WHERE paa.payroll_action_id = cp_payroll_action_id
268: AND paa.action_status = 'E'
269: )
270: AND NOT EXISTS ( SELECT '1'

Line 281: FROM pay_assignment_actions paa

277: CURSOR c_arch_retry_pending (cp_payroll_action_id NUMBER) IS
278: SELECT '1'
279: FROM dual
280: WHERE EXISTS (SELECT '1'
281: FROM pay_assignment_actions paa
282: WHERE paa.payroll_action_id = cp_payroll_action_id
283: AND paa.action_status = 'M')
284: AND NOT EXISTS (SELECT '1'
285: FROM pay_action_parameters

Line 824: pay_assignment_actions paa,

820: IF p_report_type = 'FEDW2' THEN
821: p_sqlstr := '
822: SELECT DISTINCT paf.person_id
823: FROM per_all_assignments_f paf,
824: pay_assignment_actions paa,
825: pay_payroll_actions ppa,
826: pay_payroll_actions ppa1
827: WHERE ppa1.payroll_action_id = :payroll_action_id
828: AND ppa.report_type = ''YREND''

Line 855: pay_assignment_actions paa,

851: to_number(paa.serial_number)
852: FROM ff_archive_item_contexts faic,
853: ff_archive_items fai,
854: ff_database_items fdi,
855: pay_assignment_actions paa,
856: pay_payroll_actions ppa,
857: per_all_assignments_f paf,
858: pay_payroll_actions ppa1
859: WHERE

Line 943: pay_assignment_actions paa,

939: faic.context , 2),0)
940: FROM ff_archive_item_contexts faic,
941: ff_archive_items fai,
942: ff_database_items fdi,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa,
945: per_all_assignments_f paf,
946: pay_payroll_actions ppa1
947: WHERE

Line 1007: pay_assignment_actions paa,

1003: faic.context , 2),0)
1004: FROM ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_database_items fdi,
1007: pay_assignment_actions paa,
1008: pay_payroll_actions ppa,
1009: per_all_assignments_f paf,
1010: pay_payroll_actions ppa1
1011: WHERE

Line 1057: pay_assignment_actions paa,

1053: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
1054: paf.effective_end_date,
1055: paa.assignment_action_id
1056: FROM pay_payroll_actions ppa,
1057: pay_assignment_actions paa,
1058: per_all_assignments_f paf,
1059: pay_payroll_actions ppa1
1060: WHERE ppa1.payroll_action_id = p_pactid
1061: AND ppa.report_type = 'YREND'

Line 1305: SELECT pay_assignment_actions_s.nextval

1301:
1302: END IF;
1303: IF (l_report_type = 'FEDW2' and l_value <> 0 ) OR
1304: (l_report_type = 'STW2') then
1305: SELECT pay_assignment_actions_s.nextval
1306: INTO lockingactid
1307: FROM dual;
1308: hr_utility.set_location(
1309: 'pay_us_mmref_reporting_mt.create_assignement_act', 60);

Line 1320: UPDATE pay_assignment_actions

1316: /*IF l_report_type = 'STW2' THEN
1317: hr_utility.set_location(
1318: 'pay_us_mmref_reporting_mt.create_assignement_act', 80);
1319: IF l_w2_box17 > 9999999.99 THEN
1320: UPDATE pay_assignment_actions
1321: SET serial_number = 999999
1322: WHERE assignment_action_id = lockingactid;
1323: END IF;
1324: END IF;*/ -- 4490252

Line 1521: FROM pay_assignment_actions paa

1517:
1518: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
1519: IS
1520: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
1521: FROM pay_assignment_actions paa
1522: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
1523: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
1524: ,hr_organization_units hou
1525: WHERE