APPS.PV_ATTRIBUTE_CODE_PVT dependencies on PV_ATTRIBUTE_CODES_VL

Line 284: pv_process_rules_vl rules,pv_attribute_codes_vl code

280:
281: cursor lc_check_rules (pc_attr_code_id number) is
282: select distinct seleted.attribute_value,rules.process_rule_name
283: from pv_enty_select_criteria criteria,pv_selected_attr_values seleted,
284: pv_process_rules_vl rules,pv_attribute_codes_vl code
285: where code.attr_code_id= pc_attr_code_id and
286: criteria.attribute_id= code.attribute_id and
287: criteria.selection_criteria_id= seleted.selection_criteria_id and
288: criteria.process_rule_id= rules.process_rule_id and

Line 294: pv_program_partner_types ppt, pv_attribute_codes_vl code

290:
291: cursor lc_check_programs (pc_attr_code_id number) is
292: select pp.program_id, pp.program_name, ppt.partner_type
293: from pv_partner_program_vl pp, pv_partner_program_type_b pt,
294: pv_program_partner_types ppt, pv_attribute_codes_vl code
295: where
296: pp.program_type_id = ppt.program_type_id
297: and pp.PROGRAM_STATUS_CODE NOT IN ('CANCEL', 'CLOSED','ARCHIVE')
298: and pp.program_type_id = pt.program_type_id

Line 308: from pv_enty_attr_values entyval, pv_attribute_codes_vl code

304:
305:
306: cursor lc_check_attr_enty_vals (pc_attr_code_id number) is
307: select distinct entity
308: from pv_enty_attr_values entyval, pv_attribute_codes_vl code
309: where code.attr_code_id= pc_attr_code_id and
310: code.attribute_id = entyval.attribute_id and
311: code.attr_code=entyval.attr_value and
312: entyval.latest_flag = 'Y' ;

Line 626: from pv_attribute_codes_vl code

622: l_attr_code VARCHAR2(30);
623: l_meaning VARCHAR2(80);
624: cursor lc_get_attr_code_details (pc_attr_code_id number) is
625: select code.attr_code
626: from pv_attribute_codes_vl code
627: where code.attr_code_id= pc_attr_code_id ;
628:
629: cursor lc_get_attr_details (pc_attr_code_id number) is
630: select attr.attribute_id,attr.name

Line 631: from pv_attributes_vl attr,pv_attribute_codes_vl code

627: where code.attr_code_id= pc_attr_code_id ;
628:
629: cursor lc_get_attr_details (pc_attr_code_id number) is
630: select attr.attribute_id,attr.name
631: from pv_attributes_vl attr,pv_attribute_codes_vl code
632: where code.attr_code_id= pc_attr_code_id and code.attribute_id = attr.attribute_id;
633:
634: cursor lc_check_attr_enty_vals (pc_attr_code_id number) is
635: select distinct entity

Line 636: from pv_enty_attr_values entyval, pv_attribute_codes_vl code

632: where code.attr_code_id= pc_attr_code_id and code.attribute_id = attr.attribute_id;
633:
634: cursor lc_check_attr_enty_vals (pc_attr_code_id number) is
635: select distinct entity
636: from pv_enty_attr_values entyval, pv_attribute_codes_vl code
637: where code.attr_code_id= pc_attr_code_id and
638: code.attribute_id = entyval.attribute_id and
639: code.attr_code=entyval.attr_value;
640:

Line 645: pv_process_rules_vl rules,pv_attribute_codes_vl code

641:
642: cursor lc_check_rules (pc_attr_code_id number) is
643: select distinct seleted.attribute_value,rules.process_rule_name
644: from pv_enty_select_criteria criteria,pv_selected_attr_values seleted,
645: pv_process_rules_vl rules,pv_attribute_codes_vl code
646: where code.attr_code_id= pc_attr_code_id and
647: criteria.attribute_id= code.attribute_id and
648: criteria.selection_criteria_id= seleted.selection_criteria_id and
649: criteria.process_rule_id= rules.process_rule_id and

Line 654: from pv_attribute_usages usage, pv_attribute_codes_vl code

650: seleted.attribute_value=code.attr_code;
651:
652: cursor lc_attribute_usages (pc_attr_code_id number) is
653: select distinct usage.attribute_usage_code
654: from pv_attribute_usages usage, pv_attribute_codes_vl code
655: where code.attr_code_id=pc_attr_code_id and
656: code.attr_code=usage.attribute_usage_code;
657:
658: BEGIN