APPS.ZX_JA_EXTRACT_PKG dependencies on JA_LOOKUPS

Line 333: JA_LOOKUPS ja1,

329: NOT EXISTS
330: (SELECT 1
331: FROM
332: RA_CUSTOMER_TRX_ALL rct,
333: JA_LOOKUPS ja1,
334: JA_LOOKUPS ja2,
335: JA_LOOKUPS ja3
336: WHERE
337: DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and

Line 334: JA_LOOKUPS ja2,

330: (SELECT 1
331: FROM
332: RA_CUSTOMER_TRX_ALL rct,
333: JA_LOOKUPS ja1,
334: JA_LOOKUPS ja2,
335: JA_LOOKUPS ja3
336: WHERE
337: DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
338: DET.TRX_ID = rct.customer_trx_id and

Line 335: JA_LOOKUPS ja3

331: FROM
332: RA_CUSTOMER_TRX_ALL rct,
333: JA_LOOKUPS ja1,
334: JA_LOOKUPS ja2,
335: JA_LOOKUPS ja3
336: WHERE
337: DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
338: DET.TRX_ID = rct.customer_trx_id and
339: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN (''31'',''32'',''33'',''34'',''35'',''36'',''37'') and

Line 2056: | a given lookup type from JA_LOOKUPS |

2052: | Type : Private |
2053: | Pre-req : None |
2054: | Function : |
2055: | This plug-in is used to fetch lookup meaning for |
2056: | a given lookup type from JA_LOOKUPS |
2057: | |
2058: | Called from ZX_JA_EXTRACT_PKG.POPULATE |
2059: | |
2060: | Parameters : |

Line 2152: FROM JA_LOOKUPS JA

2148: ELSE
2149: BEGIN
2150: SELECT JA.MEANING
2151: INTO X_LOOKUP_MEANING
2152: FROM JA_LOOKUPS JA
2153: WHERE JA.LOOKUP_TYPE = P_LOOKUP_TYPE and
2154: JA.LOOKUP_CODE = P_LOOKUP_CODE
2155: and p_trx_date >= start_date_active and p_trx_date <= nvl(end_date_active, p_trx_date);
2156: EXCEPTION