APPS.PV_TERR_ASSIGN_PUB dependencies on PV_ATTRIBUTE_CODES_VL

Line 2299: PV_ATTRIBUTE_CODES_VL pacv

2295: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.
2296: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
2297: SELECT partner_party_id, pacv.attr_code
2298: FROM pv_partner_profiles ppp,
2299: PV_ATTRIBUTE_CODES_VL pacv
2300: WHERE ppp.partner_id = cv_partner_id
2301: AND ppp.status = 'A'
2302: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);
2303:

Line 3371: PV_ATTRIBUTE_CODES_VL pacv

3367:
3368: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
3369: SELECT partner_party_id, pacv.attr_code
3370: FROM pv_partner_profiles ppp,
3371: PV_ATTRIBUTE_CODES_VL pacv
3372: WHERE ppp.partner_id = cv_partner_id
3373: AND ppp.status = 'A'
3374: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);
3375:

Line 3560: PV_ATTRIBUTE_CODES_VL pacv

3556: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.
3557: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
3558: SELECT partner_party_id, pacv.attr_code
3559: FROM pv_partner_profiles ppp,
3560: PV_ATTRIBUTE_CODES_VL pacv
3561: WHERE ppp.partner_id = cv_partner_id
3562: AND ppp.status = 'A'
3563: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);
3564:

Line 4126: PV_ATTRIBUTE_CODES_VL pacv

4122: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.
4123: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
4124: SELECT partner_party_id, pacv.attr_code
4125: FROM pv_partner_profiles ppp,
4126: PV_ATTRIBUTE_CODES_VL pacv
4127: WHERE ppp.partner_id = cv_partner_id
4128: AND ppp.status = 'A'
4129: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);
4130:

Line 5180: PV_ATTRIBUTE_CODES_VL pacv

5176:
5177: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
5178: SELECT partner_party_id, pacv.attr_code
5179: FROM pv_partner_profiles ppp,
5180: PV_ATTRIBUTE_CODES_VL pacv
5181: WHERE ppp.partner_id = cv_partner_id
5182: AND ppp.status = 'A'
5183: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);
5184: