APPS.DDR_REF_UTIL_PKG dependencies on DDR_R_ORG

Line 173: FROM DDR_R_ORG

169: l_valid_org_bu NUMBER;
170:
171: CURSOR cur_org IS
172: SELECT 1
173: FROM DDR_R_ORG
174: WHERE ORG_CD = p_org_cd;
175:
176: CURSOR cur_chain IS
177: SELECT 1

Line 178: FROM DDR_R_ORG_CHAIN

174: WHERE ORG_CD = p_org_cd;
175:
176: CURSOR cur_chain IS
177: SELECT 1
178: FROM DDR_R_ORG_CHAIN
179: WHERE CHAIN_CD = p_hchy_cd
180: AND ORG_CD = p_org_cd
181: AND EFF_TO_DT IS NULL;
182:

Line 185: FROM DDR_R_ORG_AREA

181: AND EFF_TO_DT IS NULL;
182:
183: CURSOR cur_area IS
184: SELECT 1
185: FROM DDR_R_ORG_AREA
186: WHERE AREA_CD = p_hchy_cd
187: AND ORG_CD = p_org_cd
188: AND EFF_TO_DT IS NULL;
189:

Line 192: FROM DDR_R_ORG_RGN

188: AND EFF_TO_DT IS NULL;
189:
190: CURSOR cur_rgn IS
191: SELECT 1
192: FROM DDR_R_ORG_RGN
193: WHERE RGN_CD = p_hchy_cd
194: AND ORG_CD = p_org_cd
195: AND EFF_TO_DT IS NULL;
196:

Line 199: FROM DDR_R_ORG_DSTRCT

195: AND EFF_TO_DT IS NULL;
196:
197: CURSOR cur_dstrct IS
198: SELECT 1
199: FROM DDR_R_ORG_DSTRCT
200: WHERE DSTRCT_CD = p_hchy_cd
201: AND ORG_CD = p_org_cd
202: AND EFF_TO_DT IS NULL;
203:

Line 206: FROM DDR_R_ORG_BSNS_UNIT

202: AND EFF_TO_DT IS NULL;
203:
204: CURSOR cur_bsns_unit IS
205: SELECT 1
206: FROM DDR_R_ORG_BSNS_UNIT
207: WHERE BSNS_UNIT_CD = p_hchy_cd
208: AND ORG_CD = p_org_cd
209: AND EFF_TO_DT IS NULL;
210: Begin

Line 539: FROM DDR_R_ORG_BSNS_ENT t1 INNER JOIN DDR_R_ORG_BSNS_ENT t2

535: t1.ORG_BSNS_ENT_ID PARENT_ID, t1.BSNS_ENT_CD PARENT_CD,
536: t2.ORG_BSNS_ENT_ID CHILD_ID, t2.BSNS_ENT_CD CHILD_CD,
537: t2.SRC_SYS_DT SRC_SYS_DT, t2.SRC_SYS_IDNT SRC_SYS_IDNT,
538: t1.EFF_FROM_DT EFF_FROM_DT, t1.EFF_TO_DT, t2.EFF_FROM_DT FROM_DT_2, t2.EFF_TO_DT TO_DT_2
539: FROM DDR_R_ORG_BSNS_ENT t1 INNER JOIN DDR_R_ORG_BSNS_ENT t2
540: ON (t1.BSNS_ENT_CD = t2.BSNS_ENT_PRNT_CD AND t1.ORG_HCHY_ID =
541: t2.ORG_HCHY_ID)
542: )
543: WHERE NOT ((TO_DT_2 is not null AND TO_DT_2 < EFF_FROM_DT) OR (EFF_TO_DT is not null AND FROM_DT_2 > EFF_TO_DT))

Line 556: FROM DDR_R_ORG_BSNS_ENT

552: ORG_BSNS_ENT_ID CHILD_ID,
553: BSNS_ENT_CD CHILD_CD,
554: SRC_SYS_DT, SRC_SYS_IDNT,
555: EFF_FROM_DT, EFF_TO_DT
556: FROM DDR_R_ORG_BSNS_ENT
557: WHERE BSNS_ENT_PRNT_CD is null
558: )
559: )
560: START WITH PARENT_CD is null