APPS.ZX_JL_EXTRACT_PKG dependencies on FND_LOOKUPS

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

7612: | GET_LOOKUP_INFO |
7613: | Type : Private |
7614: | Pre-req : None |
7615: | Function : |
7616: | This procedure fetched Lookup Code and Meaning from FND_LOOKUPS table |
7617: | using P_DOCUMENT_SUB_TYPE_TBL and returns fetched values. |
7618: | |
7619: | Called from ZX_JL_EXTRACT_PKG.POPULATE |
7620: | |

Line 7670: fnd_lookups fl

7666: INTO
7667: x_jlcl_ap_doc_type_meaning_tbl(i),
7668: x_order_by_doc_type_tbl(i)
7669: FROM
7670: fnd_lookups fl
7671: WHERE
7672: fl.lookup_type = 'JLCL_AP_DOCUMENT_TYPE'
7673: AND
7674: fl.lookup_code = substr(P_DOCUMENT_SUB_TYPE_TBL(i),15); --Bug 5413860

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

8265: | Type : Private |
8266: | Pre-req : None |
8267: | Function : |
8268: | This function returns the Customer VAT Registration Status Code |
8269: | from fnd_lookups, jl_zz_ar_tx_cus_cls and jl_zz_ar_tx_categry table to |
8270: | meet the requirement in the flat file |
8271: | |
8272: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8273: | |

Line 8386: fnd_lookups lkp

8382: SELECT lkp.meaning
8383: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
8384: FROM jl_zz_ar_tx_cus_cls_all cls,
8385: jl_zz_ar_tx_categ_all catg,
8386: fnd_lookups lkp
8387: WHERE cls.tax_attr_class_code = l_class_code
8388: AND cls.tax_attribute_name = 'VAT CONT STATUS'
8389: AND cls.tax_category_id = catg.tax_category_id
8390: AND cls.address_id = l_address_id

Line 8404: fnd_lookups lkp

8400: SELECT lkp.meaning
8401: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
8402: FROM jl_zz_ar_tx_att_cls_all cls,
8403: jl_zz_ar_tx_categ_all catg,
8404: fnd_lookups lkp
8405: WHERE cls.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
8406: AND cls.tax_attr_class_code = l_class_code
8407: AND cls.tax_attribute_name = 'VAT CONT STATUS'
8408: AND lkp.lookup_type = 'JLZZ_AR_TX_ATTR_VALUE'