DBA Data[Home] [Help]

APPS.AP_CARD_UTILITY_PKG dependencies on AP_EXPENSE_FEED_DISTS_ALL

Line 292: AP_EXPENSE_FEED_DISTS_ALL FD

288: -- CHIHO:P-CARD RELATED, IGNORED:
289: SELECT DISTINCT(NVL(FL.ORG_ID,FD.ORG_ID))
290: INTO L_ORG_ID
291: FROM AP_EXPENSE_FEED_LINES_ALL FL,
292: AP_EXPENSE_FEED_DISTS_ALL FD
293: WHERE FL.EMPLOYEE_VERIFICATION_ID = P_ID
294: OR (FD.FEED_LINE_ID = FL.FEED_LINE_ID AND
295: FD.EMPLOYEE_VERIFICATION_ID = P_ID);
296:

Line 303: FROM AP_EXPENSE_FEED_DISTS_ALL

299: ELSIF (P_MODE = 'PCARD MANAGER APPR') THEN
300: -- CHIHO:P-CARD RELATED, IGNORED:
301: SELECT DISTINCT(ORG_ID)
302: INTO L_ORG_ID
303: FROM AP_EXPENSE_FEED_DISTS_ALL
304: WHERE MANAGER_APPROVAL_ID = P_ID;
305:
306: L_FUNCTION_CODE := 'ICX_AP_WEB_OPEN_PCARD_TRANS';
307: