APPS.IGS_PE_HZ_PTY_SITES_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 88: IGS_PE_PERSON_BASE_V PE,

84: ----------------------------------------------------------------------------------------------
85: CURSOR validate_brth_dt(cp_party_site_id NUMBER ) IS
86: SELECT PE.BIRTH_DATE
87: FROM
88: IGS_PE_PERSON_BASE_V PE,
89: HZ_PARTY_SITES PTY
90: WHERE
91: PE.PERSON_ID=PTY.PARTY_ID
92: AND

Line 95: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;

91: PE.PERSON_ID=PTY.PARTY_ID
92: AND
93: PTY.PARTY_SITE_ID = cp_party_site_id ;
94:
95: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;
96:
97: BEGIN
98:
99: OPEN validate_brth_dt(p_party_site_id);

Line 139: IGS_PE_PERSON_BASE_V PE

135: ----------------------------------------------------------------------------------------------
136: CURSOR validate_brth_dt(cp_party_id NUMBER ) IS
137: SELECT PE.BIRTH_DATE
138: FROM
139: IGS_PE_PERSON_BASE_V PE
140: WHERE
141: PE.PERSON_ID= cp_party_id;
142:
143: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;

Line 143: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;

139: IGS_PE_PERSON_BASE_V PE
140: WHERE
141: PE.PERSON_ID= cp_party_id;
142:
143: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;
144:
145: BEGIN
146:
147: OPEN validate_brth_dt(p_party_id);