APPS.PAY_CA_RULES dependencies on DUAL

Line 305: DUAL;

301: 'CIBC',to_char(l_direct_deposit_date,'YYMMDD'))
302: INTO
303: l_dd_date
304: FROM
305: DUAL;
306:
307: SELECT
308: decode(l_dd_type, 'NOVA_SCOT',to_char(l_payment_date,'YYDDD'),
309: 'TD', to_char(l_payment_date,'DDMMYY'),

Line 315: DUAL;

311: 'CIBC',to_char(l_payment_date,'YYMMDD'))
312: INTO
313: l_payment_date1
314: FROM
315: DUAL;
316: l_text :=
317: '' || l_payment_date1 || '' ||
318: ''|| l_dd_date || '' ||
319: '' || l_override_cpa_code || '';

Line 513: FROM DUAL;

509:
510: SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
511: 4,'WED',5,'THU',6,'FRI',7,'SAT')
512: INTO v_curr_day
513: FROM DUAL;
514:
515: v_total_hours := v_total_hours +
516: FND_NUMBER.CANONICAL_TO_NUMBER(
517: hruserdt.get_table_value(p_bg_id,