APPS.OZF_QP_QUAL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 66: FROM hz_cust_accounts

62: l_party_id NUMBER;
63:
64: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
65: SELECT party_id
66: FROM hz_cust_accounts
67: WHERE cust_account_id = p_sold_to_org;
68:
69: /*
70: CURSOR c_bg IS

Line 141: FROM hz_cust_accounts

137: l_party_id NUMBER;
138:
139: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
140: SELECT party_id
141: FROM hz_cust_accounts
142: WHERE cust_account_id = p_sold_to_org;
143:
144: /*
145: CURSOR c_bg IS

Line 214: FROM hz_cust_accounts

210: l_party_id NUMBER;
211:
212: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
213: SELECT party_id
214: FROM hz_cust_accounts
215: WHERE cust_account_id = p_sold_to_org;
216:
217: CURSOR c_bg IS
218: SELECT r1.object_id

Line 292: FROM hz_cust_accounts

288: AND pms.market_qualifier_type IS NULL;
289:
290: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
291: SELECT party_id
292: FROM hz_cust_accounts
293: WHERE cust_account_id = p_sold_to_org;
294:
295: l_total NUMBER := 1 ;
296:

Line 342: FROM hz_cust_accounts

338: AND party_id = p_party_id;
339:
340: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
341: SELECT party_id
342: FROM hz_cust_accounts
343: WHERE cust_account_id = p_sold_to_org;
344:
345: l_total NUMBER := 1 ;
346:

Line 398: FROM hz_cust_accounts

394: WHERE party_id = p_party_id;
395:
396: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
397: SELECT party_id
398: FROM hz_cust_accounts
399: WHERE cust_account_id = p_sold_to_org;
400:
401: CURSOR cur_is_terr_setup IS
402: SELECT /*+ ORDERED */ -- julou sql performance fix

Line 730: FROM hz_cust_accounts

726: WHERE party_id = p_party_id;
727:
728: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
729: SELECT party_id
730: FROM hz_cust_accounts
731: WHERE cust_account_id = p_sold_to_org
732: AND status = 'A';
733:
734: CURSOR c_sales_channel(p_cust_acct_id NUMBER) IS

Line 736: FROM hz_cust_accounts

732: AND status = 'A';
733:
734: CURSOR c_sales_channel(p_cust_acct_id NUMBER) IS
735: SELECT sales_channel_code
736: FROM hz_cust_accounts
737: WHERE cust_account_id = p_cust_acct_id
738: and status = 'A';
739:
740: CURSOR c_cust_profile(p_sold_to NUMBER, p_ship_to NUMBER, p_bill_to NUMBER) IS

Line 1104: FROM hz_cust_accounts

1100: WHERE party_id = p_party_id;
1101:
1102: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
1103: SELECT party_id
1104: FROM hz_cust_accounts
1105: WHERE cust_account_id = p_sold_to_org;
1106:
1107: CURSOR cur_is_terr_setup IS
1108: SELECT /*+ ORDERED */ -- julou sql performance fix

Line 1436: FROM hz_cust_accounts

1432: WHERE party_id = p_party_id;
1433:
1434: CURSOR cur_get_party_id(p_sold_to_org NUMBER) IS
1435: SELECT party_id
1436: FROM hz_cust_accounts
1437: WHERE cust_account_id = p_sold_to_org;
1438:
1439: CURSOR cur_is_terr_setup IS
1440: SELECT /*+ ORDERED */ -- julou sql performance fix