APPS.PAY_IE_LE_MIGRATE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 52: FROM pay_assignment_actions paa,

48: -- Cursor to fetch all the assignment actions in 2005
49: CURSOR c_get_asg_action(p_bg_id NUMBER,p_tax_unit_id NUMBER) IS
50: SELECT paa.*,ppa.action_type action_type,ppa.effective_date effective_date,
51: ppa.report_type,ppa.report_qualifier
52: FROM pay_assignment_actions paa,
53: pay_payroll_actions ppa
54: WHERE paa.payroll_action_id = ppa.payroll_action_id
55: AND paa.action_status = 'C'
56: AND ppa.business_group_id = p_bg_id

Line 133: UPDATE pay_assignment_actions paa

129: FOR v_er_le in c_get_er_details(p_bg_id,v_er_bg.org_information8) LOOP
130:
131: FOR v_assact IN c_get_asg_action(p_bg_id,v_er_le.organization_id) LOOP
132:
133: UPDATE pay_assignment_actions paa
134: SET tax_unit_id = NULL
135: WHERE paa.assignment_action_id = v_assact.assignment_action_id;
136:
137:

Line 200: FROM pay_assignment_actions paa,

196: -- Cursor to fetch all the assignment actions in 2005
197: CURSOR c_get_asg_action(p_bg_id NUMBER,p_payroll_id NUMBER,p_start_date DATE,p_end_date DATE) IS
198: SELECT distinct paa.*,ppa.action_type action_type,ppa.effective_date effective_date,
199: ppa.report_type,ppa.report_qualifier,asg.person_id person_id
200: FROM pay_assignment_actions paa,
201: pay_payroll_actions ppa,
202: per_all_assignments_f asg
203: WHERE paa.payroll_action_id = ppa.payroll_action_id
204: AND paa.action_status = 'C'

Line 277: UPDATE pay_assignment_actions paa

273:
274: l_stage := 'Update Asg Action' || v_assact.assignment_action_id;
275: fnd_file.put_line(FND_FILE.LOG,rpad(lpad(v_assact.assignment_id,11),16)||' '||rpad(lpad(v_assact.action_type,6),11)||' '||rpad(lpad(v_assact.effective_date,11),14)||' '||rpad(lpad(v_assact.report_type,8),11));
276: -- Update the assignment actions
277: UPDATE pay_assignment_actions paa
278: SET tax_unit_id = p_org_id
279: WHERE paa.assignment_action_id = v_assact.assignment_action_id;
280:
281: IF (v_assact.report_type = 'P45' AND v_assact.report_qualifier = 'IE' AND v_assact.source_action_id IS NULL) THEN