APPS.JE_IT_LISTING_PKG dependencies on JE_IT_SETUP_LINES_ALL

Line 860: FROM je_it_setup_lines_all

856: DECODE(zxrates.def_rec_settlement_option_code, 'DEFERRED','DEFERRED',
857: zxass.REPORTING_CODE_CHAR_VALUE))<> 'CUSTOM BILL'
858:
859: AND il.tax_rate_id IN (SELECT tax_rate_id
860: FROM je_it_setup_lines_all
861: WHERE year_of_declaration = P_YEAR_OF_DECLARATION
862: AND application_id = gn_ap_app_id
863: AND vat_reporting_entity_id = gn_legal_vat_rep_entity_id);
864:

Line 1055: AND rtl.vat_tax_id IN (SELECT tax_rate_id FROM JE_IT_SETUP_LINES_ALL

1051: AND arap.applied_customer_trx_id = arct.customer_trx_id
1052: AND TO_CHAR(arct.trx_date, 'YYYY') = TO_CHAR(add_months(gd_period_end_date,-12), 'YYYY')
1053: ))
1054: )
1055: AND rtl.vat_tax_id IN (SELECT tax_rate_id FROM JE_IT_SETUP_LINES_ALL
1056: WHERE vat_reporting_entity_id = gn_legal_vat_rep_entity_id
1057: AND year_of_declaration = P_YEAR_OF_DECLARATION
1058: AND application_id= gn_ar_app_id);
1059:

Line 1195: FROM je_it_setup_lines_all

1191:
1192: CURSOR vat_ui(P_VAT_REPORTING_ENTITY_ID NUMBER,P_YEAR_OF_DECLARATION NUMBER
1193: ,P_APP_ID NUMBER,P_TAX_RATE_ID NUMBER) IS
1194: SELECT listing_column_code
1195: FROM je_it_setup_lines_all
1196: WHERE vat_reporting_entity_id=P_VAT_REPORTING_ENTITY_ID
1197: AND year_of_declaration = P_YEAR_OF_DECLARATION
1198: AND application_id = P_APP_ID
1199: AND tax_rate_id = P_TAX_RATE_ID;