347: ,l_person_id) LOOP
348:
349: SELECT pay_assignment_actions_s.nextval
350: INTO l_locking_action_id
351: FROM dual;
352:
353:
354: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,
355: assignid => rec_asg.assignment_id,
431: 'RECONCILIATION',
432: 'FUNCTION NAME',
433: p_effective_date)
434: Into l_usr_fnc_name
435: From dual;
436:
437: IF l_usr_fnc_name IS NOT NULL
438: THEN
439: EXECUTE IMMEDIATE 'select '||l_usr_fnc_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
435: From dual;
436:
437: IF l_usr_fnc_name IS NOT NULL
438: THEN
439: EXECUTE IMMEDIATE 'select '||l_usr_fnc_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
440: INTO l_return_value
441: USING p_effective_date ,
442: p_identifier_name,
443: p_payroll_action_id,