APPS.PA_PERF_OBJECT_RULES_PVT dependencies on PA_PERF_RULES

Line 90: FROM PA_PERF_RULES_V perfrule

86: dummy number ;
87: BEGIN
88: SELECT 1
89: INTO dummy
90: FROM PA_PERF_RULES_V perfrule
91: WHERE perfrule.rule_id = P_RULE_ID
92: AND (perfrule.measure_name,perfrule.period_type) in (
93: SELECT objrule.measure_name,objrule.period_type
94: FROM PA_PERF_OBJECT_RULES_V objrule

Line 112: FROM PA_PERF_RULES_v perfrule

108: dummy number ;
109: BEGIN
110: SELECT 1
111: INTO dummy
112: FROM PA_PERF_RULES_v perfrule
113: WHERE perfrule.rule_id = P_RULE_ID
114: AND perfrule.measure_name in (
115: SELECT objrule.measure_name
116: FROM PA_PERF_OBJECT_RULES_V objrule

Line 269: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.update_rule_object';

265: Raise Invalid_Ret_Status;
266: end if;
267:
268: IF l_debug_mode = 'Y' THEN
269: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.update_rule_object';
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level3);
272: END IF;
273:

Line 395: FROM PA_PERF_RULES

391:
392: BEGIN
393: SELECT RULE_NAME
394: INTO X_RULE_NAME
395: FROM PA_PERF_RULES
396: WHERE RULE_ID=(SELECT RULE_ID
397: FROM PA_PERF_OBJECT_RULES
398: WHERE OBJECT_RULE_ID=P_OBJECT_RULE_ID);
399: EXCEPTION