APPS.AHL_DI_DOC_INDEX_PUB dependencies on HZ_PARTIES

Line 86: FROM hz_parties

82: -- Used to retrieve the party id for passed meaning
83: CURSOR for_party_name(c_party_number IN VARCHAR2)
84: IS
85: SELECT party_id
86: FROM hz_parties
87: WHERE party_number = c_party_number;
88: -- Used to retrieve party id for passed id
89: CURSOR for_party_id(c_party_id IN NUMBER)
90: IS

Line 92: FROM hz_parties

88: -- Used to retrieve party id for passed id
89: CURSOR for_party_id(c_party_id IN NUMBER)
90: IS
91: SELECT party_id
92: FROM hz_parties
93: WHERE party_id = c_party_id;
94: -- Used to retrieve vendor id from po vendors
95: CURSOR for_vendor_id(c_segment1 IN VARCHAR2)
96: IS

Line 102: --Cursor to retrieve operator code from hz parties

98: FROM po_vendors
99: WHERE segment1 = c_segment1;
100:
101: --Enhancement #2275357: pbarman 1st April 2003
102: --Cursor to retrieve operator code from hz parties
103: CURSOR get_operator_name_hz(c_operator_name VARCHAR2)
104: IS
105: SELECT party_id
106: FROM HZ_PARTIES

Line 106: FROM HZ_PARTIES

102: --Cursor to retrieve operator code from hz parties
103: CURSOR get_operator_name_hz(c_operator_name VARCHAR2)
104: IS
105: SELECT party_id
106: FROM HZ_PARTIES
107: WHERE upper(party_name) = upper(c_operator_name)
108: AND ( party_type ='ORGANIZATION' or party_type = 'PERSON' );
109:
110: -- For Bug Fix #3446159

Line 114: FROM HZ_PARTIES

110: -- For Bug Fix #3446159
111: CURSOR get_operator_name_hz_id(c_operator_name VARCHAR2, c_operator_id NUMBER)
112: IS
113: SELECT party_id
114: FROM HZ_PARTIES
115: WHERE upper(party_name) = upper(c_operator_name)
116: AND party_id = c_operator_id
117: AND ( party_type ='ORGANIZATION' or party_type = 'PERSON' );
118:

Line 1315: FROM hz_parties

1311: -- Cursor is used to retrieve party id
1312: CURSOR for_party_name(c_party_number IN VARCHAR2)
1313: IS
1314: SELECT party_id
1315: FROM hz_parties
1316: WHERE party_number = c_party_number;
1317: --
1318: CURSOR for_party_id(c_party_id IN NUMBER)
1319: IS

Line 1321: FROM hz_parties

1317: --
1318: CURSOR for_party_id(c_party_id IN NUMBER)
1319: IS
1320: SELECT party_id
1321: FROM hz_parties
1322: WHERE party_id = c_party_id;
1323: -- Used to retrieve vendor id from po vendors
1324: CURSOR for_vendor_id(c_segment1 IN VARCHAR2)
1325: IS

Line 1349: --Cursor to retrieve operator code from hz parties

1345: --Added pjha for Restricting Subscription Avail to 'Yes' If supplier or subscription
1346: --Exists for the doc: End
1347:
1348: --Enhancement #2275357: pbarman 1st April 2003
1349: --Cursor to retrieve operator code from hz parties
1350: CURSOR get_operator_name_hz(c_operator_name VARCHAR2)
1351: IS
1352: SELECT party_id
1353: FROM HZ_PARTIES

Line 1353: FROM HZ_PARTIES

1349: --Cursor to retrieve operator code from hz parties
1350: CURSOR get_operator_name_hz(c_operator_name VARCHAR2)
1351: IS
1352: SELECT party_id
1353: FROM HZ_PARTIES
1354: WHERE upper(party_name) = upper(c_operator_name)
1355: AND ( party_type ='ORGANIZATION' or party_type = 'PERSON' );
1356: -- For Bug Fix #3446159
1357: CURSOR get_operator_name_hz_id(c_operator_name VARCHAR2, c_operator_id NUMBER)

Line 1360: FROM HZ_PARTIES

1356: -- For Bug Fix #3446159
1357: CURSOR get_operator_name_hz_id(c_operator_name VARCHAR2, c_operator_id NUMBER)
1358: IS
1359: SELECT party_id
1360: FROM HZ_PARTIES
1361: WHERE upper(party_name) = upper(c_operator_name)
1362: AND party_id = c_operator_id
1363: AND ( party_type ='ORGANIZATION' or party_type = 'PERSON' );
1364:

Line 1385: FROM HZ_PARTIES

1381:
1382: CURSOR for_supplier_name_hz(c_supplier_no NUMBER)
1383: IS
1384: SELECT DISTINCT PARTY_NAME
1385: FROM HZ_PARTIES
1386: WHERE PARTY_NUMBER =c_supplier_no;
1387:
1388: CURSOR for_supplier_name_po(c_supplier_no NUMBER)
1389: IS