APPS.PAY_GB_EOY_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 394: FROM pay_assignment_actions paa,

390: End 4011263 */
391: FROM pay_gb_year_end_payrolls_v a
392: WHERE a.payroll_action_id = c_payroll_action_id
393: AND EXISTS (SELECT '1'
394: FROM pay_assignment_actions paa,
395: ff_user_entities fue,
396: ff_archive_items fai
397: WHERE paa.payroll_action_id = a.payroll_action_id
398: AND fue.user_entity_name = 'X_PAYROLL_ID'

Line 485: pay_assignment_actions act

481: ff_archive_items fai1,
482: ff_user_entities fue1,
483: ff_archive_items fai2,
484: ff_user_entities fue2,
485: pay_assignment_actions act
486: WHERE act.assignment_action_id = fai1.context1
487: AND act.payroll_action_id = c_payroll_action_id
488: --AND act.action_status = 'C'
489: AND act.action_status in ('C','S') --Modified for the bug 10066755

Line 642: pay_assignment_actions paa

638: ff_archive_items fai,
639: ff_user_entities fue,
640: ff_archive_items fai2,
641: ff_user_entities fue2,
642: pay_assignment_actions paa
643: WHERE paa.payroll_action_id = c_payroll_action_id
644: AND fue.user_entity_name = 'X_NI_TOTAL_CONTRIBUTIONS'
645: AND fue.user_entity_id + decode(paa.assignment_action_id,0,0,0)
646: = fai.user_entity_id

Line 1557: from pay_assignment_actions

1553: --
1554: cursor get_errored_actions(c_payroll_action_id number) is
1555: select '1' from dual where exists
1556: (select action_status
1557: from pay_assignment_actions
1558: where payroll_action_id = c_payroll_action_id
1559: and action_status = 'E');
1560: --
1561: -- Start of BUG 5671777-5

Line 3243: from pay_assignment_actions

3239: CURSOR csr_ass_id
3240: is
3241: select
3242: assignment_id
3243: from pay_assignment_actions
3244: where assignment_action_id = c_assignment_action_id;
3245:
3246: l_assignment_id NUMBER;
3247: