APPS.PAY_CA_RULES dependencies on DUAL

Line 337: DUAL;

333: 'CIBC',to_char(l_direct_deposit_date,'YYMMDD'))
334: INTO
335: l_dd_date
336: FROM
337: DUAL;
338:
339: SELECT
340: decode(l_dd_type, 'NOVA_SCOT',to_char(l_payment_date,'YYDDD'),
341: 'TD', to_char(l_payment_date,'DDMMYY'),

Line 347: DUAL;

343: 'CIBC',to_char(l_payment_date,'YYMMDD'))
344: INTO
345: l_payment_date1
346: FROM
347: DUAL;
348: l_text :=
349: '' || l_payment_date1 || '' ||
350: ''|| l_dd_date || '' ||
351: '' || l_override_cpa_code || '';

Line 849: DUAL;

845: 'CIBC',to_char(l_direct_deposit_date,'YYMMDD'))
846: INTO
847: l_dd_date
848: FROM
849: DUAL;
850:
851: SELECT
852: decode(l_dd_type, 'NOVA_SCOT',to_char(l_payment_date,'YYDDD'),
853: 'TD', to_char(l_payment_date,'DDMMYY'),

Line 859: DUAL;

855: 'CIBC',to_char(l_payment_date,'YYMMDD'))
856: INTO
857: l_payment_date1
858: FROM
859: DUAL;
860: l_text :=
861: '' || l_payment_date1 || '' ||
862: ''|| l_dd_date || '' ||
863: '' || l_override_cpa_code || '';

Line 944: from dual;

940: 1,l_sub_unit_singular,
941: l_sub_unit_plural)
942: ))
943: into l_currency_word
944: from dual;
945:
946: RETURN(l_currency_word);
947: END get_word_value;
948:

Line 1200: FROM DUAL;

1196:
1197: SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
1198: 4,'WED',5,'THU',6,'FRI',7,'SAT')
1199: INTO v_curr_day
1200: FROM DUAL;
1201:
1202: v_total_hours := v_total_hours +
1203: FND_NUMBER.CANONICAL_TO_NUMBER(
1204: hruserdt.get_table_value(p_bg_id,