APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on DUAL

Line 289: from dual

285: and ptp.payroll_id = cp_payroll_id;
286:
287: cursor c_no_prepayments (cp_prepayment_action_id in number) is
288: select 1
289: from dual
290: where not exists
291: (select 1
292: from pay_pre_payments ppp
293: where ppp.assignment_action_id = cp_prepayment_action_id

Line 1771: FROM DUAL;

1767: , p_lookup_code VARCHAR2
1768: )
1769: IS
1770: SELECT hr_general_utilities.Get_lookup_Meaning(p_lookup_type,p_lookup_code)
1771: FROM DUAL;
1772:
1773: l_meaning hr_lookups.meaning%TYPE;
1774:
1775: BEGIN