DBA Data[Home] [Help]

APPS.PV_PROCESS_RULE_PVT dependencies on PV_ENTY_SELECT_CRITERIA

Line 661: from pv_enty_select_criteria

657:
658:
659: cursor lc_get_selcrit (pc_rule_id number) is
660: select selection_criteria_id
661: from pv_enty_select_criteria
662: where process_rule_id = pc_rule_id;
663:
664: cursor lc_get_attr_mapping (pc_rule_id number) is
665: select mapping_id

Line 1044: From PV_ENTY_SELECT_CRITERIA

1040: OBJECT_VERSION_NUMBER,REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,PROCESS_RULE_ID,
1041: ATTRIBUTE_ID, SELECTION_TYPE_CODE, OPERATOR, RANK, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
1042: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1043: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
1044: From PV_ENTY_SELECT_CRITERIA
1045: Where process_rule_id = pc_PROCESS_RULE_ID;
1046:
1047: Cursor C_Get_selected_attr_values(pc_SELECTION_CRITERIA_ID Number) IS
1048: Select ATTR_VALUE_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER,