APPS.IGS_PR_VAL_PRGC dependencies on IGS_RU_CALL

Line 12: -- only be linked to IGS_RU_CALL records with a s_rule_type_cd of 'PRG'.

8: RETURN BOOLEAN AS
9: gv_other_detail VARCHAR2(255);
10: BEGIN -- prgp_val_src_prg
11: -- Validate the IGS_PR_RU_CAT.s_rule_call_cd field can
12: -- only be linked to IGS_RU_CALL records with a s_rule_type_cd of 'PRG'.
13: DECLARE
14: v_dummy VARCHAR2(1);
15: CURSOR c_src IS
16: SELECT 'X'

Line 17: FROM IGS_RU_CALL src

13: DECLARE
14: v_dummy VARCHAR2(1);
15: CURSOR c_src IS
16: SELECT 'X'
17: FROM IGS_RU_CALL src
18: WHERE src.s_rule_call_cd = p_s_rule_call_cd AND
19: src.s_rule_type_cd = 'PRG';
20: BEGIN
21: IF p_s_rule_call_cd IS NULL THEN