807: 'RECONCILIATION',
808: 'FUNCTION NAME',
809: p_effective_date)
810: INTO l_usr_fnc_name
811: FROM dual;
812:
813: IF l_usr_fnc_name IS NOT NULL
814: THEN
815: EXECUTE IMMEDIATE 'select '||l_usr_fnc_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
811: FROM dual;
812:
813: IF l_usr_fnc_name IS NOT NULL
814: THEN
815: EXECUTE IMMEDIATE 'select '||l_usr_fnc_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
816: INTO l_return_value
817: USING p_effective_date ,
818: p_identifier_name,
819: p_payroll_action_id,