APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_PAY_SCHED_UI_GT

Line 1765: g_state := 'Bulk inserting into FII_AP_Pay_Sched_UI_GT from FII_AP_Pay_Sched_UI_MS.';

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;
1767:
1768: IF FII_AP_Pay_Sched_UI_MS.Count > 0 THEN
1769: FORALL i IN FII_AP_Pay_Sched_UI_MS.First..FII_AP_Pay_Sched_UI_MS.Last

Line 1770: INSERT INTO FII_AP_Pay_Sched_UI_GT VALUES FII_AP_Pay_Sched_UI_MS(i);

1766: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1767:
1768: IF FII_AP_Pay_Sched_UI_MS.Count > 0 THEN
1769: FORALL i IN FII_AP_Pay_Sched_UI_MS.First..FII_AP_Pay_Sched_UI_MS.Last
1770: INSERT INTO FII_AP_Pay_Sched_UI_GT VALUES FII_AP_Pay_Sched_UI_MS(i);
1771: END IF;
1772:
1773: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1774:

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

1772:
1773: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1774:
1775: if g_debug_flag = 'Y' then
1776: FII_UTIL.put_line('The time taken to bulk insert records into FII_AP_Pay_Sched_UI_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1777: end if;
1778:
1779:
1780: g_state := 'Bulk inserting into FII_AP_Aging_Bkts_B from FII_AP_Aging_Bkts_B_MS.';

Line 1866: USING FII_AP_Pay_Sched_UI_GT UI

1862:
1863: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1864:
1865: MERGE INTO FII_AP_Pay_Sched_B PSUM
1866: USING FII_AP_Pay_Sched_UI_GT UI
1867: ON (PSUM.Invoice_ID = UI.Invoice_ID
1868: AND PSUM.Payment_Num = UI.Payment_Num
1869: AND PSUM.Action_Date = UI.Action_Date
1870: AND PSUM.Action = UI.Action