APPS.AP_CARD_UTILITY_PKG dependencies on AP_EXPENSE_FEED_LINES_ALL

Line 267: L_ORG_ID AP_EXPENSE_FEED_LINES_ALL.ORG_ID%TYPE;

263: PROCEDURE JUMPINTOFUNCTION(P_ID IN NUMBER,
264: P_MODE IN VARCHAR2,
265: P_URL OUT NOCOPY VARCHAR2) IS
266: -------------------------------------------------------------------------------
267: L_ORG_ID AP_EXPENSE_FEED_LINES_ALL.ORG_ID%TYPE;
268: L_FUNCTION_CODE VARCHAR2(30);
269: L_DEBUG_INFO VARCHAR2(200);
270:
271: BEGIN

Line 281: FROM AP_EXPENSE_FEED_LINES_ALL FL,

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