APPS.PAY_MAGTAPE_EXTRACT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 735: FROM pay_assignment_actions aa

731: PROCEDURE arch_employer_loop IS
732: CURSOR employer_csr (p_payroll_action_id NUMBER,
733: p_transmitter_tax_unit_id NUMBER) IS
734: SELECT DISTINCT aa.tax_unit_id
735: FROM pay_assignment_actions aa
736: WHERE aa.payroll_action_id = p_payroll_action_id
737: UNION
738: SELECT p_transmitter_tax_unit_id
739: FROM DUAL;

Line 831: FROM pay_assignment_actions aa

827: aa.assignment_id,
828: pay_magtape_generic.date_earned (p_effective_date,aa.assignment_id)
829: date_earned,
830: aa.tax_unit_id
831: FROM pay_assignment_actions aa
832: WHERE aa.payroll_action_id = p_payroll_action_id;
833: --
834: employee_row employee_csr%ROWTYPE;
835: result ff_archive_items.value%TYPE;

Line 836: aaid pay_assignment_actions.assignment_action_id%TYPE;

832: WHERE aa.payroll_action_id = p_payroll_action_id;
833: --
834: employee_row employee_csr%ROWTYPE;
835: result ff_archive_items.value%TYPE;
836: aaid pay_assignment_actions.assignment_action_id%TYPE;
837: i INTEGER;
838: BEGIN
839: hr_utility.set_location ('arch_employee_loop',1);
840: l_next_header := 'E';

Line 859: FROM pay_assignment_actions

855: --
856: IF l_effective_date > employee_row.date_earned THEN
857: SELECT MAX(assignment_action_id)
858: INTO aaid
859: FROM pay_assignment_actions
860: WHERE tax_unit_id = employee_row.tax_unit_id AND
861: assignment_id = employee_row.assignment_id;
862: --
863: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);

Line 987: pay_assignment_actions assact,

983: WHERE EXISTS ( SELECT '1'
984: FROM ff_contexts con,
985: ff_route_context_usages rcu,
986: ff_user_entities ue,
987: pay_assignment_actions assact,
988: ff_archive_items i
989: WHERE i.archive_item_id = ic.archive_item_id
990: AND assact.payroll_action_id = p_payroll_action_id
991: AND assact.assignment_action_id = i.context1

Line 1017: pay_assignment_actions assact

1013: WHERE EXISTS ( SELECT '1'
1014: FROM ff_contexts con,
1015: ff_route_context_usages rcu,
1016: ff_user_entities ue,
1017: pay_assignment_actions assact
1018: WHERE assact.payroll_action_id = p_payroll_action_id
1019: AND assact.assignment_action_id = i.context1
1020: AND i.user_entity_id = ue.user_entity_id
1021: AND rcu.route_id = ue.route_id

Line 1039: DELETE FROM pay_assignment_actions

1035: --
1036: --------------------------------------------------------------------------------
1037: -- Delete assignment actions
1038: --------------------------------------------------------------------------------
1039: DELETE FROM pay_assignment_actions
1040: WHERE payroll_action_id = p_payroll_action_id;
1041: --
1042: --------------------------------------------------------------------------------
1043: -- Delete payroll action