DBA Data[Home] [Help]

APPS.PA_OUTPUT_TAX dependencies on PA_PROJECT_CUSTOMERS

Line 195: from hz_cust_accounts hz_c, hz_cust_acct_sites hz_cs, pa_project_customers pc

191: END IF;
192:
193: select hz_c.party_id, hz_cs.party_site_id, pc.bill_to_address_id
194: into l_bill_to_party_id, l_bill_to_party_site_id, l_bill_to_address_id
195: from hz_cust_accounts hz_c, hz_cust_acct_sites hz_cs, pa_project_customers pc
196: where pc.project_id = p_project_id
197: and pc.customer_id = p_customer_id
198: and hz_cs.cust_acct_site_id = pc.bill_to_address_id
199: and hz_c.cust_account_id = p_customer_id;

Line 211: from hz_cust_accounts hz_c, hz_cust_acct_sites hz_cs, pa_project_customers pc

207: END IF;
208:
209: select hz_c.party_id, hz_cs.party_site_id, pc.ship_to_address_id
210: into l_ship_to_party_id, l_ship_to_party_site_id, l_ship_to_address_id
211: from hz_cust_accounts hz_c, hz_cust_acct_sites hz_cs, pa_project_customers pc
212: where pc.project_id = p_project_id
213: and pc.customer_id = p_customer_id
214: and hz_cs.cust_acct_site_id = pc.ship_to_address_id
215: and hz_c.cust_account_id = p_customer_id;