APPS.PAY_GB_EOY_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 351: FROM pay_assignment_actions paa,

347: End 4011263 */
348: FROM pay_gb_year_end_payrolls_v a
349: WHERE a.payroll_action_id = c_payroll_action_id
350: AND EXISTS (SELECT '1'
351: FROM pay_assignment_actions paa,
352: ff_user_entities fue,
353: ff_archive_items fai
354: WHERE paa.payroll_action_id = a.payroll_action_id
355: AND fue.user_entity_name = 'X_PAYROLL_ID'

Line 440: pay_assignment_actions act

436: ff_archive_items fai1,
437: ff_user_entities fue1,
438: ff_archive_items fai2,
439: ff_user_entities fue2,
440: pay_assignment_actions act
441: WHERE act.assignment_action_id = fai1.context1
442: AND act.payroll_action_id = c_payroll_action_id
443: AND act.action_status = 'C'
444: AND fue1.legislation_code = 'GB'

Line 582: pay_assignment_actions paa

578: ff_archive_items fai,
579: ff_user_entities fue,
580: ff_archive_items fai2,
581: ff_user_entities fue2,
582: pay_assignment_actions paa
583: WHERE paa.payroll_action_id = c_payroll_action_id
584: AND fue.user_entity_name = 'X_NI_TOTAL_CONTRIBUTIONS'
585: AND fue.user_entity_id + decode(paa.assignment_action_id,0,0,0)
586: = fai.user_entity_id

Line 1360: from pay_assignment_actions

1356: --
1357: cursor get_errored_actions(c_payroll_action_id number) is
1358: select '1' from dual where exists
1359: (select action_status
1360: from pay_assignment_actions
1361: where payroll_action_id = c_payroll_action_id
1362: and action_status = 'E');
1363: --
1364: -- Start of BUG 5671777-5

Line 2943: from pay_assignment_actions

2939: CURSOR csr_ass_id
2940: is
2941: select
2942: assignment_id
2943: from pay_assignment_actions
2944: where assignment_action_id = c_assignment_action_id;
2945:
2946: l_assignment_id NUMBER;
2947: