APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 600: FROM hz_cust_acct_sites_all acct_site,

596: WHERE qp_list_header_id = p_list_header_id;
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

Line 1076: FROM hz_cust_acct_sites_all a,

1072: WHERE cust_account_id = p_cust_account_id;
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:

Line 1104: FROM hz_cust_acct_sites_all acct_site,

1100: WHERE qp_list_header_id = p_list_header_id;
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

Line 4146: FROM hz_cust_acct_sites_all acct_site,

4142: WHERE qp_list_header_id = p_list_header_id;
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

Line 4178: FROM hz_cust_acct_sites_all a,

4174: AND tier_type = 'PBH';
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:

Line 4814: FROM hz_cust_acct_sites_all acct_site,

4810: WHERE list_line_id = p_list_line_id;
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

Line 5333: FROM hz_cust_acct_sites_all acct_site,

5329: WHERE list_line_id = p_list_line_id;
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

Line 9017: FROM hz_cust_acct_sites_all acct_site,

9013: WHERE line_id = p_line_id;
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