APPS.FII_AP_INV_SUM_INC dependencies on DUAL

Line 967: (SELECT 'H' Rec_Type FROM DUAL WHERE dummy IS NOT NULL

963: WHERE Table_Name = 'AP_HOLDS'
964: AND Operation_Flag IN ('I','U')) LOG,
965: AP_HOLDS_ALL AH,
966: FII_AP_INVOICE_B AI,
967: (SELECT 'H' Rec_Type FROM DUAL WHERE dummy IS NOT NULL
968: UNION ALL select 'R' Rec_Type FROM DUAL WHERE dummy IS NOT NULL) RT
969: WHERE AH.Invoice_ID = LOG.Key_Value1_Num
970: AND AI.Invoice_ID = AH.Invoice_ID
971: AND AI.Cancel_Date IS NULL

Line 968: UNION ALL select 'R' Rec_Type FROM DUAL WHERE dummy IS NOT NULL) RT

964: AND Operation_Flag IN ('I','U')) LOG,
965: AP_HOLDS_ALL AH,
966: FII_AP_INVOICE_B AI,
967: (SELECT 'H' Rec_Type FROM DUAL WHERE dummy IS NOT NULL
968: UNION ALL select 'R' Rec_Type FROM DUAL WHERE dummy IS NOT NULL) RT
969: WHERE AH.Invoice_ID = LOG.Key_Value1_Num
970: AND AI.Invoice_ID = AH.Invoice_ID
971: AND AI.Cancel_Date IS NULL
972: AND AI.Invoice_Type NOT IN ('PREPAYMENT')

Line 2187: FROM dual;

2183: g_state := 'Populating g_seq_id from fii_ap_pay_sched_b';
2184:
2185: SELECT fii_ap_pay_sched_b_s.nextval
2186: INTO g_seq_id
2187: FROM dual;
2188:
2189:
2190: /* Enhancement 4227813: Manual invoice sources are defined by the profile option
2191: 'FII: Manual Invoice Sources'. Do dummy select in order to verify that the

Line 2198: execute immediate('SELECT 1 FROM (SELECT '' '' SOURCE FROM DUAL)

2194:
2195: g_manual_sources := upper(g_manual_sources);
2196: IF g_manual_sources IS NULL THEN g_manual_sources := ''''''; END IF;
2197: BEGIN
2198: execute immediate('SELECT 1 FROM (SELECT '' '' SOURCE FROM DUAL)
2199: WHERE SOURCE IN (' || g_manual_sources || ')');
2200: EXCEPTION
2201: WHEN OTHERS THEN
2202: RAISE g_invalid_manual_source;