APPS.FII_GL_TOP_SPENDERS_PKG dependencies on FII_AP_INV_B

Line 20: -- Determine whether ap base summary (FII_AP_INV_B) is populated

16:
17: BEGIN
18:
19: ----------------------------------------------------------
20: -- Determine whether ap base summary (FII_AP_INV_B) is populated
21: ----------------------------------------------------------
22: g_phase := 'Determine whether ap base summary is populated ';
23: SELECT 1 INTO l_ap_row_cnt
24: FROM FII_AP_INV_B

Line 24: FROM FII_AP_INV_B

20: -- Determine whether ap base summary (FII_AP_INV_B) is populated
21: ----------------------------------------------------------
22: g_phase := 'Determine whether ap base summary is populated ';
23: SELECT 1 INTO l_ap_row_cnt
24: FROM FII_AP_INV_B
25: WHERE rownum = 1;
26:
27: ----------------------------------------------------------
28: -- Find the schema owner of FII

Line 118: FROM fii_time_day t, FII_AP_INV_B b, FII_COM_CC_MAPPINGS m

114: g_fii_user_id,
115: sysdate,
116: g_fii_user_id,
117: g_fii_login_id
118: FROM fii_time_day t, FII_AP_INV_B b, FII_COM_CC_MAPPINGS m
119: WHERE b.discretionary_expense_flag = 'Y'
120: and b.account_Date = t.report_date
121: and b.COMPANY_ID = m.COMPANY_ID
122: and b.COST_CENTER_ID = m.COST_CENTER_ID