DBA Data[Home] [Help]

APPS.AP_CARD_UTILITY_PKG dependencies on AP_EXPENSE_FEED_DISTS_ALL

Line 282: AP_EXPENSE_FEED_DISTS_ALL FD

278: -- CHIHO:P-CARD RELATED, IGNORED:
279: SELECT DISTINCT(NVL(FL.ORG_ID,FD.ORG_ID))
280: INTO L_ORG_ID
281: FROM AP_EXPENSE_FEED_LINES_ALL FL,
282: AP_EXPENSE_FEED_DISTS_ALL FD
283: WHERE FL.EMPLOYEE_VERIFICATION_ID = P_ID
284: OR (FD.FEED_LINE_ID = FL.FEED_LINE_ID AND
285: FD.EMPLOYEE_VERIFICATION_ID = P_ID);
286:

Line 293: FROM AP_EXPENSE_FEED_DISTS_ALL

289: ELSIF (P_MODE = 'PCARD MANAGER APPR') THEN
290: -- CHIHO:P-CARD RELATED, IGNORED:
291: SELECT DISTINCT(ORG_ID)
292: INTO L_ORG_ID
293: FROM AP_EXPENSE_FEED_DISTS_ALL
294: WHERE MANAGER_APPROVAL_ID = P_ID;
295:
296: L_FUNCTION_CODE := 'ICX_AP_WEB_OPEN_PCARD_TRANS';
297: