APPS.IGS_PR_VAL_SOPC dependencies on IGS_PR_S_OU_PRG_CAL

Line 25: FROM IGS_PR_S_OU_PRG_CAL

21: DECLARE
22: v_dummy VARCHAR2(1);
23: CURSOR c_sopca IS
24: SELECT 'X'
25: FROM IGS_PR_S_OU_PRG_CAL
26: WHERE org_unit_cd = p_org_unit_cd
27: AND ou_start_dt = p_ou_start_dt
28: AND appeal_length IS NOT NULL;
29: BEGIN

Line 73: FROM IGS_PR_S_OU_PRG_CAL

69: DECLARE
70: v_dummy VARCHAR2(1);
71: CURSOR c_sopca IS
72: SELECT 'X'
73: FROM IGS_PR_S_OU_PRG_CAL
74: WHERE org_unit_cd = p_org_unit_cd
75: AND ou_start_dt = p_ou_start_dt
76: AND show_cause_length IS NOT NULL;
77: BEGIN