DBA Data[Home] [Help]

APPS.ARP_ETAX_AUTOINV_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 151: HR_ORGANIZATION_UNITS HR,

147: AR_SYSTEM_PARAMETERS AR,
148: HZ_CUST_ACCOUNTS BTCA,
149: HZ_CUST_SITE_USES BTCSU,
150: HZ_CUST_ACCT_SITES BTPS,
151: HR_ORGANIZATION_UNITS HR,
152: RA_CUSTOMER_TRX REL_T,
153: RA_CUST_TRX_TYPES REL_TT
154: WHERE T.request_id = p_request_id
155: AND NVL(T.previous_customer_trx_id, -99) =

Line 468: HR_ORGANIZATION_UNITS SR_HRL

464: SR_HRL.location_id -- poo_location_id
465: from RA_CUSTOMER_TRX TRX,
466: JTF_RS_SALESREPS SR,
467: PER_ALL_ASSIGNMENTS_F SR_PER,
468: HR_ORGANIZATION_UNITS SR_HRL
469: where TRX.customer_trx_id = ZXL.trx_id
470: and TRX.primary_salesrep_id IS NOT NULL
471: and TRX.primary_salesrep_id = SR.salesrep_id
472: and TRX.org_id = SR.org_id