[Home] [Help]
1166: open curr_lu_org_number (j.assignment_id,l_emp_end_date);
1167: fetch curr_lu_org_number into l_local_unit_org_no;
1168: close curr_lu_org_number ;
1169:
1170: select pay_assignment_actions_s.nextval
1171: into l_assact_id
1172: from dual;
1173:
1174: hr_nonrun_asact.insact (
1318: open curr_lu_org_number (j.assignment_id,l_emp_start_date);
1319: fetch curr_lu_org_number into l_local_unit_org_no;
1320: close curr_lu_org_number ;
1321:
1322: select pay_assignment_actions_s.nextval
1323: into l_assact_id
1324: from dual;
1325:
1326: hr_nonrun_asact.insact (
1597: /* Multiple entry Start*/
1598: for cnt in collemptable.first .. collemptable.last
1599: loop
1600: if collemptable (cnt).value_flag = 'Y' then
1601: select pay_assignment_actions_s.nextval
1602: into l_assact_id
1603: from dual;
1604:
1605: hr_nonrun_asact.insact (
2639: for cnt in collemptable.first .. collemptable.last
2640: loop
2641: if collemptable (cnt).value_flag = 'Y' then
2642: -- end loop;
2643: select pay_assignment_actions_s.nextval
2644: into l_assact_id
2645: from dual;
2646:
2647: hr_nonrun_asact.insact (
3013: action_information21,
3014: fnd_date.canonical_to_date(action_information22) action_information22,
3015: action_information23
3016: from pay_payroll_actions paa,
3017: pay_assignment_actions assg,
3018: pay_action_information pai
3019: where paa.payroll_action_id = p_payroll_action_id
3020: and assg.payroll_action_id = paa.payroll_action_id
3021: and pai.action_context_id = assg.assignment_action_id
3033: p_local_unit_id varchar2
3034: ) is
3035: select count(*)
3036: from pay_payroll_actions paa,
3037: pay_assignment_actions assg,
3038: pay_action_information pai
3039: where paa.payroll_action_id = p_payroll_action_id
3040: and assg.payroll_action_id = paa.payroll_action_id
3041: and pai.action_context_id = assg.assignment_action_id