APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 601: hz_cust_site_uses_all site_use,

597:
598: CURSOR c_cust_number (p_header_id IN NUMBER) IS
599: SELECT cust.cust_account_id
600: FROM hz_cust_acct_sites_all acct_site,
601: hz_cust_site_uses_all site_use,
602: hz_cust_accounts cust,
603: oe_order_headers_all header
604: WHERE header.header_id = p_header_id
605: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 662: FROM hz_cust_site_uses_all

658:
659: -- get sites org id type
660: CURSOR c_org_id (p_site_use_id IN NUMBER) IS
661: SELECT org_id
662: FROM hz_cust_site_uses_all
663: WHERE site_use_id = p_site_use_id;
664:
665: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
666: SELECT autopay_party_attr,autopay_party_id

Line 1077: hz_cust_site_uses_all b

1073:
1074: CURSOR party_site_id_csr(p_account_site_id IN NUMBER) IS
1075: SELECT a.party_site_id
1076: FROM hz_cust_acct_sites_all a,
1077: hz_cust_site_uses_all b
1078: WHERE b.site_use_id = p_account_site_id
1079: AND b.cust_acct_site_id = a.cust_acct_site_id;
1080:
1081: CURSOR sales_transation_csr(p_line_id IN NUMBER) IS

Line 1105: hz_cust_site_uses_all site_use,

1101:
1102: CURSOR c_cust_number (p_header_id IN NUMBER) IS
1103: SELECT cust.cust_account_id
1104: FROM hz_cust_acct_sites_all acct_site,
1105: hz_cust_site_uses_all site_use,
1106: hz_cust_accounts cust,
1107: oe_order_headers_all header
1108: WHERE header.header_id = p_header_id
1109: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 4147: hz_cust_site_uses_all site_use,

4143:
4144: CURSOR c_cust_number(p_header_id IN NUMBER) IS
4145: SELECT cust.cust_account_id
4146: FROM hz_cust_acct_sites_all acct_site,
4147: hz_cust_site_uses_all site_use,
4148: hz_cust_accounts cust,
4149: oe_order_headers_all header
4150: WHERE header.header_id = p_header_id
4151: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 4179: hz_cust_site_uses_all b

4175:
4176: CURSOR party_site_id_csr(p_account_site_id IN NUMBER) IS
4177: SELECT a.party_site_id
4178: FROM hz_cust_acct_sites_all a,
4179: hz_cust_site_uses_all b
4180: WHERE b.site_use_id = p_account_site_id
4181: AND b.cust_acct_site_id = a.cust_acct_site_id;
4182:
4183: --nirprasa,12.2 replace amount by plan_curr_amount

Line 4815: hz_cust_site_uses_all site_use,

4811:
4812: CURSOR c_cust_number(p_header_id IN NUMBER) IS
4813: SELECT cust.cust_account_id
4814: FROM hz_cust_acct_sites_all acct_site,
4815: hz_cust_site_uses_all site_use,
4816: hz_cust_accounts cust,
4817: oe_order_headers_all header
4818: WHERE header.header_id = p_header_id
4819: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 4864: FROM hz_cust_site_uses_all

4860:
4861: -- get sites org id type
4862: CURSOR c_org_id(p_site_use_id IN NUMBER) IS
4863: SELECT org_id
4864: FROM hz_cust_site_uses_all
4865: WHERE site_use_id = p_site_use_id;
4866:
4867: CURSOR c_sd_request_header_id(p_list_header_id IN NUMBER) IS
4868: SELECT request_header_id

Line 5334: hz_cust_site_uses_all site_use,

5330:
5331: CURSOR c_cust_number(p_header_id IN NUMBER) IS
5332: SELECT cust.cust_account_id
5333: FROM hz_cust_acct_sites_all acct_site,
5334: hz_cust_site_uses_all site_use,
5335: hz_cust_accounts cust,
5336: oe_order_headers_all header
5337: WHERE header.header_id = p_header_id
5338: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 5383: FROM hz_cust_site_uses_all

5379:
5380: -- get sites org id type
5381: CURSOR c_org_id(p_site_use_id IN NUMBER) IS
5382: SELECT org_id
5383: FROM hz_cust_site_uses_all
5384: WHERE site_use_id = p_site_use_id;
5385:
5386:
5387: l_api_name CONSTANT VARCHAR2(30) := 'Process_Result';

Line 9018: hz_cust_site_uses_all site_use,

9014:
9015: CURSOR c_cust_number (p_header_id IN NUMBER) IS
9016: SELECT cust.cust_account_id
9017: FROM hz_cust_acct_sites_all acct_site,
9018: hz_cust_site_uses_all site_use,
9019: hz_cust_accounts cust,
9020: oe_order_headers_all header
9021: WHERE header.header_id = p_header_id
9022: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id