APPS.PRIMARY_CONTACTS_MGR dependencies on JTF_PARTY_CUSTOMERS_V

Line 29: --FROM JTF_PARTY_CUSTOMERS_V

25:
26: -- new field names:
27: --SELECT PERSON_FIRST_NAME, PERSON_LAST_NAME,
28: -- PERSON_MIDDLE_NAME
29: --FROM JTF_PARTY_CUSTOMERS_V
30: --WHERE ROW_ID = P_COMPANY_ID;
31:
32: --SELECT FIRST_NAME, LAST_NAME,
33: -- MIDDLE_NAME

Line 34: --FROM JTF_PARTY_CUSTOMERS_V

30: --WHERE ROW_ID = P_COMPANY_ID;
31:
32: --SELECT FIRST_NAME, LAST_NAME,
33: -- MIDDLE_NAME
34: --FROM JTF_PARTY_CUSTOMERS_V
35: --WHERE PARTY_ID = P_COMPANY_ID;
36:
37: CURSOR primary_contacts IS
38: SELECT FIRST_NAME, LAST_NAME, MIDDLE_NAME, PARTY_ID

Line 39: FROM JTF_PARTY_CUSTOMERS_V

35: --WHERE PARTY_ID = P_COMPANY_ID;
36:
37: CURSOR primary_contacts IS
38: SELECT FIRST_NAME, LAST_NAME, MIDDLE_NAME, PARTY_ID
39: FROM JTF_PARTY_CUSTOMERS_V
40: --WHERE LAST_NAME IS NOT NULL
41: WHERE PARTY_ID = P_PARTY_ID
42: --AND PARTY_ID < 9075
43: ORDER BY 1;

Line 117: --FROM JTF_PARTY_CUSTOMERS_V

113:
114: -- new field names:
115: --SELECT PERSON_FIRST_NAME, PERSON_LAST_NAME,
116: -- PERSON_MIDDLE_NAME
117: --FROM JTF_PARTY_CUSTOMERS_V
118: --WHERE PARTY_ID = P_PARTY_ID
119:
120: --SELECT FIRST_NAME, LAST_NAME,
121: -- MIDDLE_NAME

Line 122: --FROM JTF_PARTY_CUSTOMERS_V

118: --WHERE PARTY_ID = P_PARTY_ID
119:
120: --SELECT FIRST_NAME, LAST_NAME,
121: -- MIDDLE_NAME
122: --FROM JTF_PARTY_CUSTOMERS_V
123: --WHERE PARTY_ID = P_PARTY_ID
124:
125: CURSOR primary_contacts IS
126: SELECT FIRST_NAME, LAST_NAME, MIDDLE_NAME, PARTY_ID

Line 127: FROM JTF_PARTY_CUSTOMERS_V

123: --WHERE PARTY_ID = P_PARTY_ID
124:
125: CURSOR primary_contacts IS
126: SELECT FIRST_NAME, LAST_NAME, MIDDLE_NAME, PARTY_ID
127: FROM JTF_PARTY_CUSTOMERS_V
128: --WHERE LAST_NAME IS NOT NULL
129: WHERE PARTY_ID = P_PARTY_ID
130: --AND PARTY_ID < 9075
131: ORDER BY 1;