APPS.JG_ZZ_JGZZALRL_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 5: l_entity_identifier JG_ZZ_VAT_REP_ENTITIES.entity_identifier%Type := Null;

1: PACKAGE BODY JG_ZZ_JGZZALRL_PKG AS
2: /*$Header: jgzzarlb.pls 120.0.12000000.2 2007/04/11 15:24:10 mbarrett noship $*/
3:
4: FUNCTION get_entity_identifier Return Varchar2 Is
5: l_entity_identifier JG_ZZ_VAT_REP_ENTITIES.entity_identifier%Type := Null;
6: begin
7: Select entity_identifier
8: Into l_entity_identifier
9: From JG_ZZ_VAT_REP_ENTITIES

Line 9: From JG_ZZ_VAT_REP_ENTITIES

5: l_entity_identifier JG_ZZ_VAT_REP_ENTITIES.entity_identifier%Type := Null;
6: begin
7: Select entity_identifier
8: Into l_entity_identifier
9: From JG_ZZ_VAT_REP_ENTITIES
10: where vat_reporting_entity_id = p_vat_reporting_entity_id;
11:
12: Return l_entity_identifier;
13: Exception