103: 'RECONCILIATION',
104: 'FUNCTION NAME',
105: p_effective_date)
106: Into l_usr_fnc_name
107: From dual;
108:
109: IF l_usr_fnc_name IS NOT NULL then
110:
111: EXECUTE IMMEDIATE 'select '||l_usr_fnc_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
107: From dual;
108:
109: IF l_usr_fnc_name IS NOT NULL then
110:
111: EXECUTE IMMEDIATE 'select '||l_usr_fnc_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
112: INTO l_return_value
113: USING p_effective_date ,
114: p_identifier_name,
115: p_payroll_action_id,