DBA Data[Home] [Help]

APPS.PV_ATTRIBUTE_PVT dependencies on FND_RESPONSIBILITY_VL

Line 343: from pv_attrib_resp_mappings val, FND_RESPONSIBILITY_VL resp

339: and criteria.process_rule_id= rules.process_rule_id;
340:
341: cursor lc_check_matching (pc_attribute_id number) is
342: select resp.RESPONSIBILITY_NAME
343: from pv_attrib_resp_mappings val, FND_RESPONSIBILITY_VL resp
344: where
345: val.attribute_id= pc_attribute_id and
346: resp.application_id = 691 and
347: val.entity_type = 'MANUAL_MATCHING' and

Line 842: from pv_attrib_resp_mappings val, FND_RESPONSIBILITY_VL resp

838: and criteria.process_rule_id= rules.process_rule_id;
839:
840: cursor lc_check_matching (pc_attribute_id number) is
841: select resp.RESPONSIBILITY_NAME
842: from pv_attrib_resp_mappings val, FND_RESPONSIBILITY_VL resp
843: where
844: val.attribute_id= pc_attribute_id and
845: resp.application_id = 691 and
846: val.entity_type = 'MANUAL_MATCHING' and

Line 853: FND_RESPONSIBILITY_VL resp,

849: cursor lc_check_resp_mappings (pc_attribute_id number) is
850:
851: select resp.RESPONSIBILITY_NAME, lkp.meaning
852: from pv_attrib_resp_mappings val,
853: FND_RESPONSIBILITY_VL resp,
854: pv_lookups lkp
855: where
856: val.attribute_id= pc_attribute_id and
857: resp.RESPONSIBILITY_ID = val.responsibility_id and