APPS.ZX_JL_EXTRACT_PKG dependencies on FND_LOOKUPS

Line 7224: | This procedure fetched Lookup Code and Meaning from FND_LOOKUPS table |

7220: | GET_LOOKUP_INFO |
7221: | Type : Private |
7222: | Pre-req : None |
7223: | Function : |
7224: | This procedure fetched Lookup Code and Meaning from FND_LOOKUPS table |
7225: | using P_DOCUMENT_SUB_TYPE_TBL and returns fetched values. |
7226: | |
7227: | Called from ZX_JL_EXTRACT_PKG.POPULATE |
7228: | |

Line 7278: fnd_lookups fl

7274: INTO
7275: x_jlcl_ap_doc_type_meaning_tbl(i),
7276: x_order_by_doc_type_tbl(i)
7277: FROM
7278: fnd_lookups fl
7279: WHERE
7280: fl.lookup_type = 'JLCL_AP_DOCUMENT_TYPE'
7281: AND
7282: fl.lookup_code = substr(P_DOCUMENT_SUB_TYPE_TBL(i),15); --Bug 5413860

Line 7793: | from fnd_lookups, jl_zz_ar_tx_cus_cls and jl_zz_ar_tx_categry table to |

7789: | Type : Private |
7790: | Pre-req : None |
7791: | Function : |
7792: | This function returns the Customer VAT Registration Status Code |
7793: | from fnd_lookups, jl_zz_ar_tx_cus_cls and jl_zz_ar_tx_categry table to |
7794: | meet the requirement in the flat file |
7795: | |
7796: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7797: | |

Line 7910: fnd_lookups lkp

7906: SELECT lkp.meaning
7907: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
7908: FROM jl_zz_ar_tx_cus_cls_all cls,
7909: jl_zz_ar_tx_categ_all catg,
7910: fnd_lookups lkp
7911: WHERE cls.tax_attr_class_code = l_class_code
7912: AND cls.tax_attribute_name = 'VAT CONT STATUS'
7913: AND cls.tax_category_id = catg.tax_category_id
7914: AND cls.address_id = l_address_id

Line 7928: fnd_lookups lkp

7924: SELECT lkp.meaning
7925: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
7926: FROM jl_zz_ar_tx_att_cls_all cls,
7927: jl_zz_ar_tx_categ_all catg,
7928: fnd_lookups lkp
7929: WHERE cls.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
7930: AND cls.tax_attr_class_code = l_class_code
7931: AND cls.tax_attribute_name = 'VAT CONT STATUS'
7932: AND lkp.lookup_type = 'JLZZ_AR_TX_ATTR_VALUE'