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 1983: | a given lookup type from JA_LOOKUPS |

1979: | Type : Private |
1980: | Pre-req : None |
1981: | Function : |
1982: | This plug-in is used to fetch lookup meaning for |
1983: | a given lookup type from JA_LOOKUPS |
1984: | |
1985: | Called from ZX_JA_EXTRACT_PKG.POPULATE |
1986: | |
1987: | Parameters : |

Line 2079: FROM JA_LOOKUPS JA

2075: ELSE
2076: BEGIN
2077: SELECT JA.MEANING
2078: INTO X_LOOKUP_MEANING
2079: FROM JA_LOOKUPS JA
2080: WHERE JA.LOOKUP_TYPE = P_LOOKUP_TYPE and
2081: JA.LOOKUP_CODE = P_LOOKUP_CODE
2082: and p_trx_date >= start_date_active and p_trx_date <= nvl(end_date_active, p_trx_date);
2083: EXCEPTION