APPS.FII_AP_INV_PAYMTS_F_C dependencies on FII_AP_IPAY_MSNG_RATES

Line 851: execute immediate 'select count(*) from FII_AP_IPAY_MSNG_RATES' into l_count;

847: --bug#3947925
848: --Check whether missing rates table has data or not. If not then copy missing rates
849: --from temp table to the missing rates table. This is required to avoid full refresh
850: --of the fact after application of this patch.
851: execute immediate 'select count(*) from FII_AP_IPAY_MSNG_RATES' into l_count;
852:
853: if (l_count=0) then
854: insert into fii_ap_ipay_msng_rates(Primary_Key1,
855: Primary_key2,

Line 854: insert into fii_ap_ipay_msng_rates(Primary_Key1,

850: --of the fact after application of this patch.
851: execute immediate 'select count(*) from FII_AP_IPAY_MSNG_RATES' into l_count;
852:
853: if (l_count=0) then
854: insert into fii_ap_ipay_msng_rates(Primary_Key1,
855: Primary_key2,
856: Primary_key3)
857: select Primary_key1,
858: Primary_key2,

Line 875: from fii_ap_ipay_msng_rates;

871: Primary_Key5)
872: select Primary_Key1,
873: Primary_Key2,
874: Primary_Key3
875: from fii_ap_ipay_msng_rates;
876: end if;
877:
878: -- ---------------------------------------------------------
879: -- Fetch profile option value

Line 1087: delete from fii_ap_ipay_msng_rates;

1083: --Clean up the old records from missing rates table and store the
1084: --latest records with missing rates from the current collection
1085: -- to the missing rates table from the temp table.
1086:
1087: delete from fii_ap_ipay_msng_rates;
1088:
1089: insert into fii_ap_ipay_msng_rates(Primary_Key1,
1090: Primary_Key2,
1091: Primary_Key3)

Line 1089: insert into fii_ap_ipay_msng_rates(Primary_Key1,

1085: -- to the missing rates table from the temp table.
1086:
1087: delete from fii_ap_ipay_msng_rates;
1088:
1089: insert into fii_ap_ipay_msng_rates(Primary_Key1,
1090: Primary_Key2,
1091: Primary_Key3)
1092: select Primary_Key1,
1093: Primary_Key2,