APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on DUAL

Line 353: from dual

349: and ptp.payroll_id = cp_payroll_id;
350:
351: cursor c_no_prepayments (cp_prepayment_action_id in number) is
352: select 1
353: from dual
354: where not exists
355: (select 1
356: from pay_pre_payments ppp
357: where ppp.assignment_action_id = cp_prepayment_action_id

Line 1959: or l_actual_termination_date < ptp.start_date)),0) into l_term_diff from dual;

1955: select nvl((select 1
1956: from per_time_periods ptp
1957: where time_period_id = l_time_period_id
1958: and( l_actual_termination_date between ptp.start_date and ptp.end_date
1959: or l_actual_termination_date < ptp.start_date)),0) into l_term_diff from dual;
1960:
1961: IF nvl(l_term_diff,0) = 0 THEN
1962: /* Calling this cursor to retain the existing behavior as that will return no recs and hence
1963: takes the default rout i.e Y*/

Line 2417: FROM DUAL;

2413: , p_lookup_code VARCHAR2
2414: )
2415: IS
2416: SELECT hr_general_utilities.Get_lookup_Meaning(p_lookup_type,p_lookup_code)
2417: FROM DUAL;
2418:
2419: l_meaning hr_lookups.meaning%TYPE;
2420:
2421: BEGIN