DBA Data[Home] [Help]

APPS.PV_PARTNER_ATTR_LOAD_PUB dependencies on PV_ENTY_ATTR_VALUES

Line 724: pv_enty_attr_values

720: CURSOR l_get_glbl_member_type(cv_partner_id IN NUMBER) is
721: SELECT
722: attr_value
723: from
724: pv_enty_attr_values
725: where
726: attribute_id = 6 and
727: latest_flag = 'Y' and
728: entity_id = cv_partner_id;

Line 1098: pv_enty_attr_values

1094: CURSOR l_get_partner_type(cv_partner_id IN NUMBER) IS
1095: select
1096: attr_value
1097: from
1098: pv_enty_attr_values
1099: where
1100: entity_id = cv_partner_id and
1101: attribute_id = 3 and
1102: latest_flag = 'Y';

Line 1443: pv_enty_attr_values

1439: CURSOR l_get_attr_version(cv_entity_id IN NUMBER, cv_attr_id IN Number) IS
1440: SELECT
1441: max(version)
1442: FROM
1443: pv_enty_attr_values
1444: WHERE
1445: attribute_id = cv_attr_id and
1446: entity_id = cv_entity_id;
1447:

Line 1480: pv_enty_attr_values

1476: CURSOR l_get_partner_type(cv_partner_id IN NUMBER) IS
1477: select
1478: attr_value
1479: from
1480: pv_enty_attr_values
1481: where
1482: entity_id = cv_partner_id and
1483: attribute_id = 3 and
1484: latest_flag = 'Y';