APPS.JL_ZZ_AUTO_INVOICE dependencies on FND_LOOKUPS

Line 144: FROM fnd_lookups

140: l_dummy_code := NULL;
141: BEGIN
142: SELECT 'Sucess'
143: INTO l_dummy_code
144: FROM fnd_lookups
145: WHERE lookup_code = p_product_fiscal_class
146: AND lookup_type = 'JLZZ_AR_TX_FISCAL_CLASS_CODE'
147: AND enabled_flag = 'Y'
148: AND sysdate between nvl(start_date_active,sysdate)

Line 201: FROM fnd_lookups

197: instr(p_trx_business_category,l_delimiter,-1)+1);
198:
199: SELECT 'Sucess'
200: INTO l_dummy_code
201: FROM fnd_lookups
202: WHERE lookup_code = l_trx_business_category
203: AND lookup_type = 'TRANSACTION_CLASS'
204: AND enabled_flag = 'Y'
205: AND sysdate BETWEEN nvl(start_date_active,sysdate)

Line 303: FROM fnd_lookups

299:
300: BEGIN
301: SELECT 'Success'
302: INTO dummy_code
303: FROM fnd_lookups
304: WHERE lookup_code = p_header_attribute1
305: AND lookup_type = 'JLBR_INTEREST_PENALTY_TYPE'
306: AND enabled_flag = 'Y'
307: AND nvl(start_date_active,sysdate) <= sysdate

Line 413: FROM fnd_lookups

409:
410: BEGIN
411: SELECT 'Success'
412: INTO dummy_code
413: FROM fnd_lookups
414: WHERE lookup_code = p_header_attribute4
415: AND lookup_type = 'JLBR_INTEREST_FORMULA'
416: AND enabled_flag = 'Y'
417: AND nvl(start_date_active,sysdate) <= sysdate

Line 479: FROM fnd_lookups

475:
476: BEGIN
477: SELECT 'Success'
478: INTO dummy_code
479: FROM fnd_lookups
480: WHERE lookup_code = p_header_attribute6
481: AND lookup_type = 'JLBR_INTEREST_PENALTY_TYPE'
482: AND enabled_flag = 'Y'
483: AND nvl(start_date_active,sysdate) <= sysdate

Line 813: FROM fnd_lookups

809: /* Lookup Type value modified by Sierra on 06/11/99 */
810:
811: SELECT 'Success'
812: INTO dummy_code
813: FROM fnd_lookups
814: WHERE lookup_code = p_line_attribute4
815: AND lookup_type = 'JLBR_ITEM_ORIGIN'
816: AND nvl (end_date_active, sysdate + 1) > sysdate;
817:

Line 881: FROM fnd_lookups

877: /* New Code for MLS by Sierra on 03/29/99 */
878:
879: SELECT 'Success'
880: INTO dummy_code
881: FROM fnd_lookups
882: WHERE lookup_code = p_line_attribute5
883: AND lookup_type = 'JLBR_ITEM_FISCAL_TYPE'
884: AND nvl (end_date_active, sysdate + 1) > sysdate;
885:

Line 949: FROM fnd_lookups

945: /* New Code for MLS by Sierra on 03/29/99 */
946:
947: SELECT 'Success'
948: INTO dummy_code
949: FROM fnd_lookups
950: WHERE lookup_code = p_line_attribute6
951: AND lookup_type = 'JLBR_ITEM_FEDERAL_SITUATION'
952: AND nvl (end_date_active, sysdate + 1) > sysdate;
953:

Line 1017: FROM fnd_lookups

1013: /* New Code for MLS by Sierra on 03/29/99 */
1014:
1015: SELECT 'Success'
1016: INTO dummy_code
1017: FROM fnd_lookups
1018: WHERE lookup_code = p_line_attribute7
1019: AND lookup_type = 'JLBR_ITEM_STATE_SITUATION'
1020: AND nvl (end_date_active, sysdate + 1) > sysdate;
1021: