DBA Data[Home] [Help]

APPS.ARP_ETAX_AUTOINV_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 149: HR_ORGANIZATION_UNITS HR,

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

Line 453: HR_ORGANIZATION_UNITS SR_HRL

449: SR_HRL.location_id -- poo_location_id
450: from RA_CUSTOMER_TRX TRX,
451: JTF_RS_SALESREPS SR,
452: PER_ALL_ASSIGNMENTS_F SR_PER,
453: HR_ORGANIZATION_UNITS SR_HRL
454: where TRX.customer_trx_id = ZXL.trx_id
455: and TRX.primary_salesrep_id IS NOT NULL
456: and TRX.primary_salesrep_id = SR.salesrep_id
457: and TRX.org_id = SR.org_id