APPS.HZ_SECONDARY_TRANSFORM_PKG dependencies on HZ_MATCH_RULE_SECONDARY

Line 71: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval

67: l_dummy VARCHAR2(1);
68: BEGIN
69: l_count := 1;
70: WHILE l_count > 0 LOOP
71: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval
72: into px_SECONDARY_TRANSFORM_ID FROM sys.dual;
73: BEGIN
74: SELECT 'Y' INTO l_dummy
75: FROM HZ_MATCH_RULE_SECONDARY

Line 75: FROM HZ_MATCH_RULE_SECONDARY

71: SELECT HZ_MATCH_RULE_SECONDARY_s.nextval
72: into px_SECONDARY_TRANSFORM_ID FROM sys.dual;
73: BEGIN
74: SELECT 'Y' INTO l_dummy
75: FROM HZ_MATCH_RULE_SECONDARY
76: WHERE SECONDARY_ATTRIBUTE_ID = px_SECONDARY_TRANSFORM_ID ;
77: l_count := 1;
78: EXCEPTION WHEN NO_DATA_FOUND THEN
79: l_count := 0;