DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_OR_GEN_001

Line 1216: IGS_OR_GEN_001.ORGP_GET_WITHIN_OU(

1212: WHERE ou.PARTY_NUMBER LIKE p_responsible_org_unit_cd AND
1213: ou.org_status = os.org_status AND
1214: ou.inst_org_ind = 'O' AND
1215: os.s_org_status = cst_active AND
1216: IGS_OR_GEN_001.ORGP_GET_WITHIN_OU(
1217: ou.PARTY_NUMBER,
1218: ou.start_dt,
1219: crv.responsible_org_unit_cd,
1220: crv.responsible_ou_start_dt,

Line 1336: IGS_OR_GEN_001.ORGP_GET_WITHIN_OU(

1332: IGS_OR_STATUS os
1333: WHERE ou.org_unit_cd LIKE p_responsible_org_unit_cd AND
1334: ou.org_status = os.org_status AND
1335: os.s_org_status = cst_active AND
1336: IGS_OR_GEN_001.ORGP_GET_WITHIN_OU(
1337: ou.org_unit_cd,
1338: ou.start_dt,
1339: crv.responsible_org_unit_cd,
1340: crv.responsible_ou_start_dt,'N') = 'Y' ) ) AND