APPS.PQH_RBC_ELPRO dependencies on BEN_ELIGY_CRITERIA

Line 27: from ben_eligy_criteria

23: into p_criteria_id, P_CRIT_COL1_DATATYPE,
24: p_CRITERIA_TYPE, p_ALLOW_RANGE_VALIDATION_FLAG,
25: p_CRIT_COL1_VAL_TYPE_CD, P_CRIT_COL2_DATATYPE,
26: p_ALLOW_RANGE_VALIDATION_FLAG2,p_CRIT_COL2_VAL_TYPE_CD
27: from ben_eligy_criteria
28: where short_code = p_short_code
29: and business_group_id = p_business_group_id;
30:
31:

Line 44: from ben_eligy_criteria

40: into p_criteria_id, P_CRIT_COL1_DATATYPE,
41: p_CRITERIA_TYPE, p_ALLOW_RANGE_VALIDATION_FLAG,
42: p_CRIT_COL1_VAL_TYPE_CD, P_CRIT_COL2_DATATYPE,
43: p_ALLOW_RANGE_VALIDATION_FLAG2,p_CRIT_COL2_VAL_TYPE_CD
44: from ben_eligy_criteria
45: where short_code = p_short_code
46: and business_group_id is null;
47: end;
48: when too_many_rows then