[Home] [Help]
73: p_person_id NUMBER) IS
74: SELECT act.assignment_action_id,
75: act.assignment_id,
76: ppp.pre_payment_id
77: FROM pay_assignment_actions act,
78: per_all_assignments_f asg,
79: pay_payroll_actions pa2,
80: pay_payroll_actions pa1,
81: pay_pre_payments ppp,
114: AND hr_asg.assignment_id = asg.assignment_id
115: ))
116: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
117: FROM pay_action_interlocks pai1,
118: pay_assignment_actions act2,
119: pay_payroll_actions appa
120: WHERE pai1.locked_action_id = act.assignment_action_id
121: AND act2.assignment_action_id = pai1.locking_action_id
122: AND act2.payroll_action_id = appa.payroll_action_id
165: ,l_consolidation_set
166: ,l_assignment_set_id
167: ,l_person_id) LOOP
168:
169: SELECT pay_assignment_actions_s.nextval
170: INTO l_locking_action_id
171: FROM dual;
172:
173: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,
1404: l_proc CONSTANT VARCHAR2 (72) := l_package|| '.read_record';
1405:
1406: --local variables
1407: l_own_ref varchar2(50);
1408: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE ;
1409:
1410:
1411: /* cursor to get the emp no from the assignment_action_id */
1412: CURSOR csr_emp_no(v_asg_act_id pay_assignment_actions.assignment_action_id%TYPE)
1408: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE ;
1409:
1410:
1411: /* cursor to get the emp no from the assignment_action_id */
1412: CURSOR csr_emp_no(v_asg_act_id pay_assignment_actions.assignment_action_id%TYPE)
1413: IS
1414: SELECT ppf.employee_number
1415: FROM per_all_people_f ppf,
1416: per_all_assignments_f paf,
1413: IS
1414: SELECT ppf.employee_number
1415: FROM per_all_people_f ppf,
1416: per_all_assignments_f paf,
1417: pay_assignment_actions paa
1418: WHERE ppf.person_id=paf.person_id
1419: AND paf.assignment_id=paa.assignment_id
1420: AND paa.assignment_action_id=v_asg_act_id;
1421: