APPS.ZX_AP_POPULATE_PKG dependencies on FND_LOOKUPS

Line 3692: FROM fnd_lookups

3688:
3689: CURSOR lookup_cur (c_lookup_type VARCHAR2,
3690: c_lookup_code VARCHAR2) IS
3691: SELECT meaning, description
3692: FROM fnd_lookups
3693: WHERE lookup_type = c_lookup_type
3694: AND lookup_code = c_lookup_code;
3695:
3696: l_tbl_index_lookup BINARY_INTEGER;

Line 3773: l_meaning fnd_lookups.meaning%TYPE;

3769: PROCEDURE bulk_populate_zx_dtl
3770: (p_register_type IN VARCHAR2 -- P_TRL_GLOBAL_VARIABLES_REC.REGISTER_TYPE
3771: ) IS
3772:
3773: l_meaning fnd_lookups.meaning%TYPE;
3774:
3775: BEGIN
3776:
3777: BEGIN

Line 3780: FROM fnd_lookups

3776:
3777: BEGIN
3778: SELECT meaning
3779: INTO l_meaning
3780: FROM fnd_lookups
3781: WHERE lookup_type = 'ZX_TRL_REGISTER_TYPE'
3782: AND lookup_code = p_register_type;
3783: EXCEPTION
3784: WHEN OTHERS THEN

Line 3795: FROM fnd_lookups

3791: DECODE(tax_recoverable_flag,'Y','TAX'
3792: ,'NON-RECOVERABLE')
3793: ,(tax_rate_code_vat_trx_type_mng,tax_rate_vat_trx_type_desc) =
3794: (SELECT meaning, description
3795: FROM fnd_lookups
3796: WHERE lookup_type = 'ZX_JEBE_VAT_TRANS_TYPE'
3797: AND lookup_code = zx_dtl.tax_rate_vat_trx_type_code
3798: )
3799: ,trx_class_mng = CASE WHEN trx_line_class IS NULL THEN NULL

Line 3802: FROM fnd_lookups

3798: )
3799: ,trx_class_mng = CASE WHEN trx_line_class IS NULL THEN NULL
3800: ELSE
3801: (SELECT meaning
3802: FROM fnd_lookups
3803: WHERE lookup_type = 'ZX_TRL_TAXABLE_TRX_TYPE'
3804: AND lookup_code = zx_dtl.trx_line_class
3805: )
3806: END

Line 3810: FROM fnd_lookups

3806: END
3807: ,tax_type_mng = CASE WHEN tax_type_code IS NULL THEN NULL
3808: ELSE
3809: (SELECT meaning
3810: FROM fnd_lookups
3811: WHERE lookup_type = 'ZX_TAX_TYPE_CATEGORY'
3812: AND lookup_code = zx_dtl.tax_type_code
3813: )
3814: END