[Home] [Help]
1332: open curr_lu_org_number (j.assignment_id,l_emp_end_date);
1333: fetch curr_lu_org_number into l_local_unit_org_no;
1334: close curr_lu_org_number ;
1335:
1336: select pay_assignment_actions_s.nextval
1337: into l_assact_id
1338: from dual;
1339:
1340: hr_nonrun_asact.insact (
1484: open curr_lu_org_number (j.assignment_id,l_emp_start_date);
1485: fetch curr_lu_org_number into l_local_unit_org_no;
1486: close curr_lu_org_number ;
1487:
1488: select pay_assignment_actions_s.nextval
1489: into l_assact_id
1490: from dual;
1491:
1492: hr_nonrun_asact.insact (
1763: /* Multiple entry Start*/
1764: for cnt in collemptable.first .. collemptable.last
1765: loop
1766: if collemptable (cnt).value_flag = 'Y' then
1767: select pay_assignment_actions_s.nextval
1768: into l_assact_id
1769: from dual;
1770:
1771: hr_nonrun_asact.insact (
2826: for cnt in collemptable.first .. collemptable.last
2827: loop
2828: if collemptable (cnt).value_flag = 'Y' then
2829: -- end loop;
2830: select pay_assignment_actions_s.nextval
2831: into l_assact_id
2832: from dual;
2833:
2834: hr_nonrun_asact.insact (
3200: action_information21,
3201: fnd_date.canonical_to_date(action_information22) action_information22,
3202: action_information23
3203: from pay_payroll_actions paa,
3204: pay_assignment_actions assg,
3205: pay_action_information pai
3206: where paa.payroll_action_id = p_payroll_action_id
3207: and assg.payroll_action_id = paa.payroll_action_id
3208: and pai.action_context_id = assg.assignment_action_id
3220: p_local_unit_id varchar2
3221: ) is
3222: select count(*)
3223: from pay_payroll_actions paa,
3224: pay_assignment_actions assg,
3225: pay_action_information pai
3226: where paa.payroll_action_id = p_payroll_action_id
3227: and assg.payroll_action_id = paa.payroll_action_id
3228: and pai.action_context_id = assg.assignment_action_id