APPS.FII_AP_SCH_PAYMTS_F_C dependencies on FII_AP_SCHP_MSNG_RATES

Line 865: execute immediate 'select count(*) from FII_AP_SCHP_MSNG_RATES' into l_count;

861: --bug#3947925
862: --Check whether missing rates table has data or not. If not then copy missing rates
863: --from temp table to the missing rates table. This is required to avoid full refresh
864: --of the fact after application of this patch.
865: execute immediate 'select count(*) from FII_AP_SCHP_MSNG_RATES' into l_count;
866:
867: if (l_count=0) then
868: insert into fii_ap_schp_msng_rates(Primary_Key1,
869: Primary_key2,

Line 868: insert into fii_ap_schp_msng_rates(Primary_Key1,

864: --of the fact after application of this patch.
865: execute immediate 'select count(*) from FII_AP_SCHP_MSNG_RATES' into l_count;
866:
867: if (l_count=0) then
868: insert into fii_ap_schp_msng_rates(Primary_Key1,
869: Primary_key2,
870: Primary_key3)
871: select Primary_key1,
872: Primary_key2,

Line 889: from fii_ap_schp_msng_rates;

885: Primary_Key5)
886: select Primary_Key1,
887: Primary_Key2,
888: Primary_Key3
889: from fii_ap_schp_msng_rates;
890: end if;
891:
892: -- ---------------------------------------------------------
893: -- Fetch profile option value

Line 1099: delete from fii_ap_schp_msng_rates;

1095: --Clean up the old records from missing rates table and store the
1096: --latest records with missing rates from the current collection
1097: -- to the missing rates table from the temp table.
1098:
1099: delete from fii_ap_schp_msng_rates;
1100:
1101: insert into fii_ap_schp_msng_rates(Primary_Key1,
1102: Primary_Key2,
1103: Primary_Key3)

Line 1101: insert into fii_ap_schp_msng_rates(Primary_Key1,

1097: -- to the missing rates table from the temp table.
1098:
1099: delete from fii_ap_schp_msng_rates;
1100:
1101: insert into fii_ap_schp_msng_rates(Primary_Key1,
1102: Primary_Key2,
1103: Primary_Key3)
1104: select Primary_Key1,
1105: Primary_Key2,