APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_ASSIGNMENT_ACTIONS

Line 229: FROM pay_assignment_actions paa_act,

225: AND paf.business_group_id+0 = p_business_group_id
226: AND paf.assignment_type = 'E'
227: AND EXISTS
228: (SELECT 'x'
229: FROM pay_assignment_actions paa_act,
230: pay_payroll_actions ppa_act
231: WHERE paa_act.assignment_id = paf.assignment_id
232: AND paa_act.tax_unit_id = cp_tax_unit_id
233: AND ppa_act.payroll_action_id = paa_act.payroll_action_id

Line 259: pay_assignment_actions paa_act

255: AND paf.assignment_type = 'E'
256: AND EXISTS (
257: SELECT 'x'
258: FROM pay_payroll_actions ppa_act,
259: pay_assignment_actions paa_act
260: WHERE paa_act.assignment_id = paf.assignment_id
261: AND paa_act.tax_unit_id = cp_tax_unit_id
262: AND ppa_act.payroll_action_id = paa_act.payroll_action_id
263: AND ppa_act.action_type IN ('R', 'Q', 'B', 'I', 'V')

Line 294: FROM pay_assignment_actions paa

290: CURSOR c_arch_errored_asg (cp_payroll_action_id NUMBER) IS
291: SELECT '1'
292: FROM dual
293: WHERE EXISTS (SELECT '1'
294: FROM pay_assignment_actions paa
295: WHERE paa.payroll_action_id = cp_payroll_action_id
296: AND paa.action_status = 'E'
297: )
298: AND NOT EXISTS ( SELECT '1'

Line 310: FROM pay_assignment_actions paa

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

Line 357: pay_assignment_actions paa,

353: IS
354: SELECT 'Y'
355: FROM
356: ff_archive_items fai,
357: pay_assignment_actions paa,
358: pay_payroll_actions ppa
359: WHERE ppa.PAYROLL_ACTION_ID = CP_PAYROLL_ACTION_ID
360: AND ppa.payroll_action_id = paa.payroll_action_id
361: AND paa.assignment_action_id = fai.context1

Line 807: pay_assignment_actions paa,

803: IF p_report_type = 'FEDW2' THEN
804: p_sqlstr := '
805: SELECT DISTINCT paf.person_id
806: FROM per_assignments_f paf,
807: pay_assignment_actions paa,
808: pay_payroll_actions ppa,
809: pay_payroll_actions ppa1
810: WHERE ppa1.payroll_action_id = :payroll_action_id
811: AND ppa.report_type = ''YREND''

Line 838: pay_assignment_actions paa,

834: to_number(paa.serial_number)
835: FROM ff_archive_item_contexts faic,
836: ff_archive_items fai,
837: ff_database_items fdi,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa,
840: per_assignments_f paf,
841: pay_payroll_actions ppa1
842: WHERE

Line 925: pay_assignment_actions paa,

921: faic.context , 2),0)
922: FROM ff_archive_item_contexts faic,
923: ff_archive_items fai,
924: ff_database_items fdi,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,
927: per_assignments_f paf,
928: pay_payroll_actions ppa1
929: WHERE

Line 975: pay_assignment_actions paa,

971: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
972: paf.effective_end_date,
973: paa.assignment_action_id
974: FROM pay_payroll_actions ppa,
975: pay_assignment_actions paa,
976: --hr_soft_coding_keyflex hsck,
977: per_assignments_f paf,
978: pay_payroll_actions ppa1
979: WHERE ppa1.payroll_action_id = p_pactid

Line 1109: SELECT pay_assignment_actions_s.nextval

1105: close csr_get_fed_wages;
1106: END IF;
1107: IF (l_report_type = 'FEDW2' and l_value > 0) OR
1108: (l_report_type = 'STW2') then
1109: SELECT pay_assignment_actions_s.nextval
1110: INTO lockingactid
1111: FROM dual;
1112: hr_utility.set_location(
1113: 'pay_us_magw2_reporting.create_assignement_act', 60);

Line 1124: UPDATE pay_assignment_actions

1120: IF l_report_type = 'STW2' THEN
1121: hr_utility.set_location(
1122: 'pay_us_magw2_reporting.create_assignement_act', 80);
1123: IF l_w2_box17 > 9999999.99 THEN
1124: UPDATE pay_assignment_actions
1125: SET serial_number = 999999
1126: WHERE assignment_action_id = lockingactid;
1127: END IF;
1128: END IF;