APPS.AHL_DI_DOC_INDEX_PVT dependencies on HZ_PARTIES

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

128: -- AND lookup_type = 'AHL_OPERATOR_TYPE'
129: -- AND sysdate between nvl(start_date_active,sysdate)
130: -- AND nvl(end_date_active,sysdate);
131:
132: --Cursor to retrieve operator code from hz parties
133: --Enhancement no #2275357 : pbarman : April 2003
134: CURSOR get_operator_code_hz(c_operator_code VARCHAR2)
135: IS
136: SELECT party_id

Line 137: FROM HZ_PARTIES

133: --Enhancement no #2275357 : pbarman : April 2003
134: CURSOR get_operator_code_hz(c_operator_code VARCHAR2)
135: IS
136: SELECT party_id
137: FROM HZ_PARTIES
138: WHERE party_id = c_operator_code
139: AND ( party_type ='ORGANIZATION' or party_type = 'PERSON' );
140:
141:

Line 1207: FROM HZ_PARTIES

1203:
1204: CURSOR get_supplier_name_hz(c_supplier_id NUMBER)
1205: IS
1206: SELECT party_number
1207: FROM HZ_PARTIES
1208: WHERE party_id =c_supplier_id;
1209:
1210: CURSOR get_supplier_name_po(c_supplier_id NUMBER)
1211: IS

Line 1382: FROM HZ_PARTIES

1378:
1379: CURSOR get_supplier_name_hz(c_supplier_id NUMBER)
1380: IS
1381: SELECT party_number
1382: FROM HZ_PARTIES
1383: WHERE party_id =c_supplier_id;
1384:
1385: CURSOR get_supplier_name_po(c_supplier_id NUMBER)
1386: IS

Line 1737: FROM HZ_PARTIES

1733:
1734: CURSOR get_supplier_name_hz(c_supplier_id NUMBER)
1735: IS
1736: SELECT party_number
1737: FROM HZ_PARTIES
1738: WHERE party_id =c_supplier_id;
1739:
1740: CURSOR get_supplier_name_po(c_supplier_id NUMBER)
1741: IS

Line 2105: FROM HZ_PARTIES

2101:
2102: CURSOR get_supplier_name_hz(c_supplier_id NUMBER)
2103: IS
2104: SELECT party_number
2105: FROM HZ_PARTIES
2106: WHERE party_id =c_supplier_id;
2107:
2108: CURSOR get_supplier_name_po(c_supplier_id NUMBER)
2109: IS

Line 2342: FROM hz_parties

2338:
2339: CURSOR DUP_REC_NAME(c_recipient_party_id NUMBER)
2340: IS
2341: SELECT party_number
2342: FROM hz_parties
2343: WHERE party_id = c_recipient_party_id;
2344:
2345:
2346:

Line 2459: FROM hz_parties

2455:
2456: CURSOR DUP_REC_NAME(c_recipient_party_id NUMBER)
2457: IS
2458: SELECT party_number
2459: FROM hz_parties
2460: WHERE party_id = c_recipient_party_id;
2461:
2462: l_dup_rec_name varchar2(360);
2463: --