DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 511: from jg_zz_vat_rep_entities jzvre

507: BEGIN
508: select distinct nvl(jzvre.ledger_id,0)
509: , jzvre.entity_type_code
510: into l_ledger_id,l_entity_type_code
511: from jg_zz_vat_rep_entities jzvre
512: where jzvre.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID;
513: EXCEPTION
514: WHEN OTHERS THEN
515: l_ledger_id := 0;

Line 549: from jg_zz_vat_rep_entities

545: LOG_MESSAGE_MAIN := fnd_message.get;
546: fnd_file.put_line(fnd_file.log,LOG_MESSAGE_MAIN);
547: select ENTITY_IDENTIFIER
548: into l_ent_name_main
549: from jg_zz_vat_rep_entities
550: where VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID;
551: fnd_file.put_line(fnd_file.log,'>>>>>'||l_ent_name_main);
552: raise_application_error(-20010,LOG_MESSAGE_MAIN);
553: END IF;

Line 2523: from jg_zz_vat_rep_entities

2519: fnd_file.put_line(fnd_file.log,LOG_MESSAGE_835);
2520: FOR i IN 1..l_ent_index-1 LOOP
2521: select ENTITY_IDENTIFIER
2522: into l_ent_name
2523: from jg_zz_vat_rep_entities
2524: where VAT_REPORTING_ENTITY_ID = l_ent_list(i).ent_id;
2525: fnd_file.put_line(fnd_file.log,'>>>>>'||l_ent_name);
2526: END LOOP;
2527: raise_application_error(-20010,LOG_MESSAGE_835);