DBA Data[Home] [Help]

APPS.PV_PTR_MEMBER_TYPE_PVT dependencies on PV_ATTRIBUTE_CODES_VL

Line 94: FROM PV_ATTRIBUTE_CODES_VL

90:
91: l_value VARCHAR2(1);
92: CURSOR memb_csr( attr_cd VARCHAR2 ) IS
93: SELECT 'X'
94: FROM PV_ATTRIBUTE_CODES_VL
95: WHERE ATTRIBUTE_ID = 6
96: AND ENABLED_FLAG = 'Y'
97: AND ATTR_CODE =attr_cd;
98:

Line 391: FROM PV_ATTRIBUTE_CODES_VL

387: WHERE party_id=p_ptnr_party_id;
388:
389: CURSOR get_memb_csr ( attr_cd IN VARCHAR2 ) IS
390: SELECT DESCRIPTION
391: FROM PV_ATTRIBUTE_CODES_VL
392: WHERE ATTRIBUTE_ID = 6
393: AND ENABLED_FLAG = 'Y'
394: AND ATTR_CODE =attr_cd;
395:

Line 1582: FROM PV_ATTRIBUTE_CODES_VL

1578: l_to_party_name VARCHAR2(360);
1579:
1580: CURSOR get_memb_csr ( attr_cd IN VARCHAR2 ) IS
1581: SELECT DESCRIPTION
1582: FROM PV_ATTRIBUTE_CODES_VL
1583: WHERE ATTRIBUTE_ID = 6
1584: AND ENABLED_FLAG = 'Y'
1585: AND ATTR_CODE =attr_cd;
1586: