APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_PAY_SCHED_D_GT

Line 1751: g_state := 'Bulk inserting into FII_AP_Pay_Sched_D_GT from FII_AP_Pay_Sched_D_MS.';

1747: if g_debug_flag = 'Y' then
1748: FII_UTIL.put_line('The time taken to bulk insert records into FII_AP_Invoice_UI_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1749: end if;
1750:
1751: g_state := 'Bulk inserting into FII_AP_Pay_Sched_D_GT from FII_AP_Pay_Sched_D_MS.';
1752: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1753:
1754: IF FII_AP_Pay_Sched_D_MS.Count > 0 THEN
1755: FORALL i IN FII_AP_Pay_Sched_D_MS.First..FII_AP_Pay_Sched_D_MS.Last

Line 1756: INSERT INTO FII_AP_Pay_Sched_D_GT VALUES FII_AP_Pay_Sched_D_MS(i);

1752: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1753:
1754: IF FII_AP_Pay_Sched_D_MS.Count > 0 THEN
1755: FORALL i IN FII_AP_Pay_Sched_D_MS.First..FII_AP_Pay_Sched_D_MS.Last
1756: INSERT INTO FII_AP_Pay_Sched_D_GT VALUES FII_AP_Pay_Sched_D_MS(i);
1757: END IF;
1758:
1759: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1760:

Line 1762: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Pay_Sched_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1758:
1759: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1760:
1761: if g_debug_flag = 'Y' then
1762: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Pay_Sched_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1763: end if;
1764:
1765: g_state := 'Bulk inserting into FII_AP_Pay_Sched_UI_GT from FII_AP_Pay_Sched_UI_MS.';
1766: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1844: FROM FII_AP_Pay_Sched_D_GT D

1840:
1841: DELETE FROM FII_AP_Pay_Sched_B PSUM
1842: WHERE EXISTS
1843: (SELECT 1
1844: FROM FII_AP_Pay_Sched_D_GT D
1845: WHERE D.Invoice_ID = PSUM.Invoice_ID
1846: AND D.Payment_Num = PSUM.Payment_Num
1847: AND D.Action_Date = PSUM.Action_Date
1848: AND D.Action = PSUM.Action