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 991: pay_assignment_actions paa, /* YREND PAA */

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

Line 1052: pay_assignment_actions paa,

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

Line 1211: SELECT pay_assignment_actions_s.nextval

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

Line 1227: UPDATE pay_assignment_actions

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

Line 1427: FROM pay_assignment_actions paa

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