APPS.PAY_US_MMREF_LOCAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 309: FROM pay_assignment_actions paa

305: CURSOR c_arch_errored_asg (cp_payroll_action_id NUMBER) IS
306: SELECT '1'
307: FROM dual
308: WHERE EXISTS (SELECT '1'
309: FROM pay_assignment_actions paa
310: WHERE paa.payroll_action_id = cp_payroll_action_id
311: AND paa.action_status = 'E'
312: )
313: AND NOT EXISTS ( SELECT '1'

Line 324: FROM pay_assignment_actions paa

320: CURSOR c_arch_retry_pending (cp_payroll_action_id NUMBER) IS
321: SELECT '1'
322: FROM dual
323: WHERE EXISTS (SELECT '1'
324: FROM pay_assignment_actions paa
325: WHERE paa.payroll_action_id = cp_payroll_action_id
326: AND paa.action_status = 'M')
327: AND NOT EXISTS (SELECT '1'
328: FROM pay_action_parameters

Line 872: pay_assignment_actions paa,

868: IF p_report_type = 'FEDW2' THEN
869: p_sqlstr := '
870: SELECT DISTINCT paf.person_id
871: FROM per_all_assignments_f paf,
872: pay_assignment_actions paa,
873: pay_payroll_actions ppa,
874: pay_payroll_actions ppa1
875: WHERE ppa1.payroll_action_id = :payroll_action_id
876: AND ppa.report_type = ''YREND''

Line 903: pay_assignment_actions paa,

899: to_number(paa.serial_number)
900: FROM ff_archive_item_contexts faic,
901: ff_archive_items fai,
902: ff_database_items fdi,
903: pay_assignment_actions paa,
904: pay_payroll_actions ppa,
905: per_all_assignments_f paf,
906: pay_payroll_actions ppa1
907: WHERE

Line 992: pay_assignment_actions paa, /* YREND PAA */

988: paa.assignment_action_id,
989: fai1.value
990:
991: FROM
992: pay_assignment_actions paa, /* YREND PAA */
993: pay_payroll_actions ppa, /* YREND PPA */
994: per_all_assignments_f paf,
995: pay_payroll_actions ppa1,
996: ff_contexts fc1 , --for city context

Line 1053: pay_assignment_actions paa,

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

Line 1212: SELECT pay_assignment_actions_s.nextval

1208: close csr_get_fed_wages;
1209: END IF;
1210: IF (l_report_type = 'FEDW2' and l_value > 0) OR
1211: (l_report_type = 'STW2') then
1212: SELECT pay_assignment_actions_s.nextval
1213: INTO lockingactid
1214: FROM dual;
1215: hr_utility.set_location(
1216: 'pay_us_mmref_reporting.create_assignement_act', 60);

Line 1228: UPDATE pay_assignment_actions

1224: IF l_report_type = 'STW2' THEN
1225: hr_utility.set_location(
1226: 'pay_us_mmref_reporting.create_assignement_act', 80);
1227: IF l_w2_box17 > 999999999.99 THEN
1228: UPDATE pay_assignment_actions
1229: SET serial_number = 9999999
1230: WHERE assignment_action_id = lockingactid;
1231: END IF;
1232: END IF;

Line 1428: FROM pay_assignment_actions paa

1424:
1425: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
1426: IS
1427: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
1428: FROM pay_assignment_actions paa
1429: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
1430: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
1431: ,hr_organization_units hou
1432: WHERE