APPS.JL_ZZ_AUTO_INVOICE dependencies on FND_LOOKUPS

Line 145: FROM fnd_lookups

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

Line 203: FROM fnd_lookups

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

Line 306: FROM fnd_lookups

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

Line 416: FROM fnd_lookups

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

Line 482: FROM fnd_lookups

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

Line 824: FROM fnd_lookups

820: /* Lookup Type value modified by Sierra on 06/11/99 */
821:
822: SELECT 'Success'
823: INTO dummy_code
824: FROM fnd_lookups
825: WHERE lookup_code = p_line_attribute4
826: AND lookup_type = 'JLBR_ITEM_ORIGIN'
827: AND nvl (end_date_active, sysdate + 1) > sysdate;
828:

Line 892: FROM fnd_lookups

888: /* New Code for MLS by Sierra on 03/29/99 */
889:
890: SELECT 'Success'
891: INTO dummy_code
892: FROM fnd_lookups
893: WHERE lookup_code = p_line_attribute5
894: AND lookup_type = 'JLBR_ITEM_FISCAL_TYPE'
895: AND nvl (end_date_active, sysdate + 1) > sysdate;
896:

Line 960: FROM fnd_lookups

956: /* New Code for MLS by Sierra on 03/29/99 */
957:
958: SELECT 'Success'
959: INTO dummy_code
960: FROM fnd_lookups
961: WHERE lookup_code = p_line_attribute6
962: AND lookup_type = 'JLBR_ITEM_FEDERAL_SITUATION'
963: AND nvl (end_date_active, sysdate + 1) > sysdate;
964:

Line 1028: FROM fnd_lookups

1024: /* New Code for MLS by Sierra on 03/29/99 */
1025:
1026: SELECT 'Success'
1027: INTO dummy_code
1028: FROM fnd_lookups
1029: WHERE lookup_code = p_line_attribute7
1030: AND lookup_type = 'JLBR_ITEM_STATE_SITUATION'
1031: AND nvl (end_date_active, sysdate + 1) > sysdate;
1032: