APPS.AP_CARD_UTILITY_PKG dependencies on AP_EXPENSE_FEED_LINES_ALL

Line 277: L_ORG_ID AP_EXPENSE_FEED_LINES_ALL.ORG_ID%TYPE;

273: PROCEDURE JUMPINTOFUNCTION(P_ID IN NUMBER,
274: P_MODE IN VARCHAR2,
275: P_URL OUT NOCOPY VARCHAR2) IS
276: -------------------------------------------------------------------------------
277: L_ORG_ID AP_EXPENSE_FEED_LINES_ALL.ORG_ID%TYPE;
278: L_FUNCTION_CODE VARCHAR2(30);
279: L_DEBUG_INFO VARCHAR2(200);
280:
281: BEGIN

Line 291: FROM AP_EXPENSE_FEED_LINES_ALL FL,

287: IF (P_MODE = 'PCARD EMP VERI') THEN
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);