[Home] [Help]
74: p_le_id number) IS
75: SELECT act.assignment_action_id,
76: act.assignment_id,
77: ppp.pre_payment_id
78: FROM pay_assignment_actions act,
79: per_all_assignments_f asg,
80: pay_payroll_actions pa2,
81: pay_payroll_actions pa1,
82: pay_pre_payments ppp,
122: AND hr_asg.INCLUDE_OR_EXCLUDE = 'I'
123: ))
124: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
125: FROM pay_action_interlocks pai1,
126: pay_assignment_actions act2,
127: pay_payroll_actions appa
128: WHERE pai1.locked_action_id = act.assignment_action_id
129: AND act2.assignment_action_id = pai1.locking_action_id
130: AND act2.payroll_action_id = appa.payroll_action_id
180: ,l_assignment_set_id
181: ,l_person_id
182: ,l_le_id) LOOP
183:
184: SELECT pay_assignment_actions_s.nextval
185: INTO l_locking_action_id
186: FROM dual;
187:
188: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,
1428: l_proc CONSTANT VARCHAR2 (72) := l_package|| '.read_record';
1429:
1430: --local variables
1431: l_own_ref varchar2(50);
1432: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE ;
1433: l_act_id per_all_assignments_f.assignment_id%TYPE ;
1434:
1435: /* cursor to get the emp no from the assignment_id for BETFOR22*/
1436: CURSOR csr_emp_no(v_act_id per_all_assignments_f.assignment_id%TYPE)
1442: AND paf.assignment_id=v_act_id;
1443:
1444:
1445: /* cursor to get the emp no from the assignment_action_id BETFOR23*/
1446: CURSOR csr_emp_no_1(v_asg_act_id pay_assignment_actions.assignment_action_id%TYPE)
1447: IS
1448: SELECT ppf.employee_number
1449: FROM per_all_people_f ppf,
1450: per_all_assignments_f paf,
1447: IS
1448: SELECT ppf.employee_number
1449: FROM per_all_people_f ppf,
1450: per_all_assignments_f paf,
1451: pay_assignment_actions paa
1452: WHERE ppf.person_id=paf.person_id
1453: AND paf.assignment_id=paa.assignment_id
1454: AND paa.assignment_action_id=v_asg_act_id;
1455: