DBA Data[Home] [Help]

APPS.JG_ZZ_JOURNAL_AR_PKG dependencies on JG_ZZ_VAT_REGISTERS_VL

Line 105: FROM jg_zz_vat_registers_vl jzvr

101: BEGIN
102:
103: SELECT register_name
104: INTO l_vat_register_name
105: FROM jg_zz_vat_registers_vl jzvr
106: ,jg_zz_vat_rep_entities jzvre
107: WHERE ((jzvre.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
108: and
109: jzvre.entity_type_code = 'ACCOUNTING'

Line 148: FROM jg_zz_vat_registers_vl jzvr

144: BEGIN
145:
146: SELECT register_name
147: INTO l_vat_register_name
148: FROM jg_zz_vat_registers_vl jzvr
149: ,jg_zz_vat_rep_entities jzvre
150: WHERE ((jzvre.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
151: and
152: jzvre.entity_type_code = 'ACCOUNTING'

Line 685: ,jg_zz_vat_registers_vl JZVRV

681: ,JZVTD.trx_currency_code TRX_CURRENCY_CODE
682: ,JZVTD.TRX_DUE_DATE TRX_DUE_DATE
683: ,JZVTD.ACCOUNTING_DATE ACCOUNTING_DATE
684: FROM jg_zz_vat_trx_details JZVTD
685: ,jg_zz_vat_registers_vl JZVRV
686: ,jg_zz_vat_rep_status JZVRS
687: ,jg_zz_vat_doc_sequences JZVDS
688: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
689: AND JZVRV.vat_reporting_entity_id = JZVRS.mapping_vat_rep_entity_id

Line 862: ,jg_zz_vat_registers_vl JZVRV

858: ,SUBSTR(JZVTD.billing_tp_name,1,90) PARTY_NAME
859: ,SUBSTR(JZVTD.billing_tp_name,1,22) VAT_REGISTER_NAME
860: ,JZVTD.posted_flag POSTED_FLAG
861: FROM jg_zz_vat_trx_details JZVTD
862: ,jg_zz_vat_registers_vl JZVRV
863: ,jg_zz_vat_rep_status JZVRS
864: ,ar_lookups LK
865: ,jg_zz_vat_doc_sequences JZVDS
866: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID