APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on DUAL

Line 160: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

156: EXCEPTION
157: WHEN OTHERS THEN
158: hr_utility.set_location('Exception****',70);
159: -- Return cursor that selects no rows
160: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
161: END RANGE_CODE;
162:
163: /* ASSIGNMENT ACTION CODE PAY_NO_ARC_HOLIDAY_ENTITLEMENT.ASSIGNMENT_ACTION_CODE */
164:

Line 240: FROM DUAL;

236: LOOP
237:
238: SELECT pay_assignment_actions_s.NEXTVAL
239: INTO l_actid
240: FROM DUAL;
241:
242: hr_nonrun_asact.insact (l_actid,
243: csr_act.assignment_id,
244: p_payroll_action_id,