DBA Data[Home] [Help]

APPS.PV_PROCESS_RULE_PVT dependencies on PV_ENTITY_ATTR_MAPPINGS

Line 666: from pv_entity_attr_mappings

662: where process_rule_id = pc_rule_id;
663:
664: cursor lc_get_attr_mapping (pc_rule_id number) is
665: select mapping_id
666: from pv_entity_attr_mappings
667: where process_rule_id = pc_rule_id;
668:
669: cursor lc_get_entity_routing (pc_rule_id number) is
670: select entity_routing_id

Line 1061: From PV_ENTITY_ATTR_MAPPINGS

1057: REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,PROCESS_RULE_ID,SOURCE_ATTR_TYPE,
1058: SOURCE_ATTR_ID,TARGET_ATTR_TYPE,TARGET_ATTR_ID,OPERATOR,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,
1059: ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,
1060: ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
1061: From PV_ENTITY_ATTR_MAPPINGS
1062: Where process_rule_id = pc_PROCESS_RULE_ID;
1063:
1064: Cursor C_Get_entity_routings(pc_PROCESS_RULE_ID Number) IS
1065: Select ENTITY_ROUTING_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER,