APPS.IGS_PR_GEN_004 dependencies on IGS_CA_DA_INST

Line 2733: FROM IGS_CA_DA_INST dai1

2729: cs.CAL_STATUS = ci.CAL_STATUS AND
2730: cs.s_CAL_STATUS = cst_active AND
2731: EXISTS (
2732: SELECT 'X'
2733: FROM IGS_CA_DA_INST dai1
2734: WHERE ci.cal_type = dai1.cal_type AND
2735: ci.sequence_number = dai1.ci_sequence_number AND
2736: (
2737: EXISTS ( SELECT 1 FROM IGS_PR_S_PRG_CONF spc1

Line 2753: FROM IGS_CA_DA_INST dai2

2749: ci.sequence_number
2750: ) <= TRUNC(SYSDATE)) AND
2751: EXISTS (
2752: SELECT 'X'
2753: FROM IGS_CA_DA_INST dai2
2754: WHERE ci.cal_type = dai2.cal_type AND
2755: ci.sequence_number = dai2.ci_sequence_number AND
2756: (
2757: EXISTS ( SELECT 1 FROM IGS_PR_S_PRG_CONF spc2

Line 5128: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;

5124: IS
5125: BEGIN -- prgpl_sca_apply_rules
5126: DECLARE
5127: v_rul_sequence_number IGS_PR_RULE.rul_sequence_number%TYPE;
5128: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
5129: v_passed_ind VARCHAR2(1);
5130: v_sprc_passed_ind VARCHAR2(1);
5131: CURSOR c_pr (
5132: cp_progression_rule_cat IGS_PR_RULE.progression_rule_cat%TYPE,