APPS.PA_PERF_OBJECT_RULES_PVT dependencies on PA_PERF_OBJECT_RULES_V

Line 94: FROM PA_PERF_OBJECT_RULES_V objrule

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
95: WHERE objrule.object_id = P_OBJECT_ID ) ;
96: PA_UTILS.ADD_MESSAGE
97: ( p_app_short_name => 'PA',
98: p_msg_name => 'PA_EXCP_PROJ_DUP_MEASURE_CAL');

Line 116: FROM PA_PERF_OBJECT_RULES_V objrule

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
117: WHERE objrule.object_id = P_OBJECT_ID ) ;
118: PA_UTILS.ADD_MESSAGE
119: ( p_app_short_name => 'PA',
120: p_msg_name => 'PA_EXCP_PROJ_RULE_DUP_MEASURE');

Line 486: FROM PA_PERF_OBJECT_RULES_V objrule

482: IS
483: CURSOR RULES_IN_ERROR IS
484: SELECT objrule.measure_name,objrule.period_type,count(*),
485: objrule.measure_id --Added for the bug# 3639474
486: FROM PA_PERF_OBJECT_RULES_V objrule
487: WHERE objrule.object_id = P_OBJECT_ID
488: AND objrule.rule_type='PERF_RULE'
489: GROUP BY objrule.measure_name,objrule.period_type, objrule.measure_id
490: HAVING count(*) >1;

Line 494: FROM PA_PERF_OBJECT_RULES_V objrule

490: HAVING count(*) >1;
491:
492: CURSOR RULE_NAMES_IN_ERROR (l_measure_id IN NUMBER ,l_period_type IN VARCHAR2 ) IS --Changed the parameter l_measure_name VARCHAR2 to l_measure_id NUMBER for bug# 3639474
493: SELECT objrule.RULE_NAME
494: FROM PA_PERF_OBJECT_RULES_V objrule
495: WHERE objrule.object_id = P_OBJECT_ID
496: --AND objrule.measure_name = l_measure_name --commented for the bug# 3639474
497: AND objrule.measure_id = l_measure_id --Added for the bug# 3639474
498: AND objrule.period_type =l_period_type;

Line 503: FROM PA_PERF_OBJECT_RULES_V objrule

499:
500: CURSOR RULES_IN_WARNING IS
501: SELECT objrule.measure_name,count(*),
502: objrule.measure_id ----Added for the bug# 3639474
503: FROM PA_PERF_OBJECT_RULES_V objrule
504: WHERE objrule.object_id = P_OBJECT_ID
505: AND objrule.rule_type='PERF_RULE'
506: AND EXISTS (select 1 from PA_PERF_OBJECT_RULES rule
507: where rule.record_version_number = 1 -- Changed hardcoded value from 2 to 1

Line 508: and rule.rule_id in (select rule_id from PA_PERF_OBJECT_RULES_V objrule1

504: WHERE objrule.object_id = P_OBJECT_ID
505: AND objrule.rule_type='PERF_RULE'
506: AND EXISTS (select 1 from PA_PERF_OBJECT_RULES rule
507: where rule.record_version_number = 1 -- Changed hardcoded value from 2 to 1
508: and rule.rule_id in (select rule_id from PA_PERF_OBJECT_RULES_V objrule1
509: where objrule1.rule_id = rule.rule_id
510: and objrule1.measure_name=objrule.measure_name)
511: and rule.object_id=P_OBJECT_ID)
512: GROUP BY objrule.measure_name, objrule.measure_id

Line 517: FROM PA_PERF_OBJECT_RULES_V objrule

513: HAVING count(*) >1;
514:
515: CURSOR RULE_NAMES_IN_WARNING (l_measure_id IN NUMBER ) IS --Changed the parameter l_measure_name VARCHAR2 to l_measure_id NUMBER for bug# 3639474
516: SELECT objrule.RULE_NAME
517: FROM PA_PERF_OBJECT_RULES_V objrule
518: WHERE objrule.object_id = P_OBJECT_ID
519: --AND objrule.measure_name = l_measure_name; --commented for the bug# 3639474
520: AND objrule.measure_id = l_measure_id; --Added for the bug# 3639474
521: