APPS.JL_INTERFACE_VAL dependencies on FND_LOOKUPS

Line 518: FROM fnd_lookups

514: IF (p_global_attribute11 IS NOT NULL) THEN
515: BEGIN
516: SELECT 'X'
517: INTO value_exists
518: FROM fnd_lookups
519: WHERE lookup_type = 'JLAR_LEGAL_TRX_CATEGORY'
520: AND lookup_code = p_global_attribute11
521: AND nvl(start_date_active,sysdate) <= sysdate
522: AND nvl(end_date_active,sysdate) >= sysdate

Line 552: FROM fnd_lookups

548: IF (p_global_attribute12 IS NOT NULL) THEN
549: BEGIN
550: SELECT 'X'
551: INTO value_exists
552: FROM fnd_lookups
553: WHERE lookup_type = 'JLAR_DOCUMENT_LETTER'
554: AND lookup_code = p_global_attribute12
555: AND nvl(start_date_active,sysdate) <= sysdate
556: AND nvl(end_date_active,sysdate) >= sysdate

Line 687: FROM fnd_lookups

683:
684: BEGIN
685: SELECT 'X'
686: INTO value_exists
687: FROM fnd_lookups
688: WHERE lookup_type = 'YES_NO'
689: AND lookup_code = p_global_attribute17
690: AND nvl(start_date_active,sysdate) <= sysdate
691: AND nvl(end_date_active,sysdate) >= sysdate

Line 1854: from fnd_lookups

1850: SELECT 'x'
1851: INTO l_lookup_code
1852: FROM dual
1853: WHERE exists (select lookup_code
1854: from fnd_lookups
1855: where lookup_type = 'JLAR_TAXID_TYPE'
1856: and lookup_code = p_glob_attr_set1.global_attribute10);
1857: EXCEPTION
1858: WHEN NO_DATA_FOUND THEN

Line 2386: FROM fnd_lookups

2382: IF (p_global_attribute1 IS NOT NULL) THEN
2383: BEGIN
2384: SELECT 'X'
2385: INTO value_exists
2386: FROM fnd_lookups
2387: WHERE lookup_type = 'YES_NO'
2388: AND lookup_code = p_global_attribute1
2389: AND nvl(start_date_active,sysdate) <= sysdate
2390: AND nvl(end_date_active,sysdate) >= sysdate

Line 2441: FROM fnd_lookups

2437: IF (p_global_attribute3 IS NOT NULL) THEN
2438: BEGIN
2439: SELECT 'X'
2440: INTO value_exists
2441: FROM fnd_lookups
2442: WHERE lookup_type = 'JLBR_INVOICE_SERIES'
2443: AND lookup_code = p_global_attribute3
2444: AND nvl(start_date_active,sysdate) <= sysdate
2445: AND nvl(end_date_active,sysdate) >= sysdate

Line 2467: FROM fnd_lookups

2463: IF (p_global_attribute4 IS NOT NULL) THEN
2464: BEGIN
2465: SELECT 'X'
2466: INTO value_exists
2467: FROM fnd_lookups
2468: WHERE lookup_type = 'JLBR_INVOICE_CLASS'
2469: AND lookup_code = p_global_attribute4
2470: AND nvl(start_date_active,sysdate) <= sysdate
2471: AND nvl(end_date_active,sysdate) >= sysdate

Line 2913: FROM fnd_lookups

2909: IF p_glob_attr_set2.global_attribute1 IS NOT NULL THEN
2910: BEGIN
2911: SELECT 1
2912: INTO dummy_code
2913: FROM fnd_lookups
2914: WHERE lookup_code=p_glob_attr_set2.global_attribute1
2915: AND lookup_type = 'YES_NO'
2916: AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
2917: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE

Line 2932: FROM fnd_lookups

2928: IF p_glob_attr_set2.global_attribute2 IS NOT NULL THEN
2929: BEGIN
2930: SELECT 1
2931: INTO dummy_code
2932: FROM fnd_lookups
2933: WHERE lookup_code=p_glob_attr_set2.global_attribute2
2934: AND lookup_type = 'YES_NO'
2935: AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
2936: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE

Line 3104: FROM fnd_lookups

3100: IF (p_global_attribute19 IS NOT NULL) THEN
3101: BEGIN
3102: SELECT 'X'
3103: INTO value_exists
3104: FROM fnd_lookups
3105: WHERE lookup_type = 'JLCL_AP_DOCUMENT_TYPE'
3106: AND lookup_code = p_global_attribute19
3107: AND nvl(start_date_active,sysdate) <= sysdate
3108: AND nvl(end_date_active,sysdate) >= sysdate