APPS.OZF_QP_QUAL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 69: FROM hz_cust_accounts

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

Line 144: FROM hz_cust_accounts

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

Line 217: FROM hz_cust_accounts

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

Line 295: FROM hz_cust_accounts

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

Line 345: FROM hz_cust_accounts

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

Line 401: FROM hz_cust_accounts

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

Line 733: FROM hz_cust_accounts

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

Line 739: FROM hz_cust_accounts

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

Line 1107: FROM hz_cust_accounts

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

Line 1439: FROM hz_cust_accounts

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