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 1121: FROM HZ_PARTIES

1117:
1118: CURSOR get_supplier_name_hz(c_supplier_id NUMBER)
1119: IS
1120: SELECT party_number
1121: FROM HZ_PARTIES
1122: WHERE party_id =c_supplier_id;
1123:
1124: CURSOR get_supplier_name_po(c_supplier_id NUMBER)
1125: IS

Line 1296: FROM HZ_PARTIES

1292:
1293: CURSOR get_supplier_name_hz(c_supplier_id NUMBER)
1294: IS
1295: SELECT party_number
1296: FROM HZ_PARTIES
1297: WHERE party_id =c_supplier_id;
1298:
1299: CURSOR get_supplier_name_po(c_supplier_id NUMBER)
1300: IS

Line 1651: FROM HZ_PARTIES

1647:
1648: CURSOR get_supplier_name_hz(c_supplier_id NUMBER)
1649: IS
1650: SELECT party_number
1651: FROM HZ_PARTIES
1652: WHERE party_id =c_supplier_id;
1653:
1654: CURSOR get_supplier_name_po(c_supplier_id NUMBER)
1655: IS

Line 2019: FROM HZ_PARTIES

2015:
2016: CURSOR get_supplier_name_hz(c_supplier_id NUMBER)
2017: IS
2018: SELECT party_number
2019: FROM HZ_PARTIES
2020: WHERE party_id =c_supplier_id;
2021:
2022: CURSOR get_supplier_name_po(c_supplier_id NUMBER)
2023: IS

Line 2256: FROM hz_parties

2252:
2253: CURSOR DUP_REC_NAME(c_recipient_party_id NUMBER)
2254: IS
2255: SELECT party_number
2256: FROM hz_parties
2257: WHERE party_id = c_recipient_party_id;
2258:
2259:
2260:

Line 2373: FROM hz_parties

2369:
2370: CURSOR DUP_REC_NAME(c_recipient_party_id NUMBER)
2371: IS
2372: SELECT party_number
2373: FROM hz_parties
2374: WHERE party_id = c_recipient_party_id;
2375:
2376: l_dup_rec_name varchar2(360);
2377: --