DBA Data[Home] [Help]

APPS.XTR_HEDGE_PROCESS_P dependencies on HR_OPERATING_UNITS

Line 1694: from hr_operating_units

1690: and cust_acct.cust_account_id = p_customer_id;
1691:
1692: cursor ar_org is
1693: select name
1694: from hr_operating_units
1695: where organization_id = l_ar_org_id;
1696:
1697: -- AR Related Variables and cursors End
1698:

Line 1737: from hr_operating_units

1733: where vendor_id = p_vendor_id;
1734:
1735: cursor ap_org is
1736: select name
1737: from hr_operating_units
1738: where organization_id = l_ap_org_id;
1739:
1740: -- AP Related Variables and cursors End
1741:

Line 2121: hr_operating_units ho,

2117:
2118: Cursor ar_source(p_source in VARCHAR2, p_company in VARCHAR2) is
2119: select '(BATCH_SOURCE_ID = '|| batch_source_id || ' AND ORG_ID = '||org_id||') OR ' source
2120: from ra_batch_sources_all bs,
2121: hr_operating_units ho,
2122: xtr_parties_v xp
2123: where bs.org_id = ho.organization_id
2124: and ho.set_of_books_id = (SELECT glle.ledger_id FROM gl_ledger_le_v glle
2125: WHERE glle.legal_entity_id = xp.legal_entity_id

Line 2133: hr_operating_units ho,

2129:
2130: Cursor ar_trxtype(p_trxtype in VARCHAR2, p_company in VARCHAR2) is
2131: select '(CUST_TRX_TYPE_ID = '|| cust_trx_type_id || ' AND ORG_ID = '||org_id||') OR ' trxtype
2132: from ra_cust_trx_types_all tt,
2133: hr_operating_units ho,
2134: xtr_parties_v xp
2135: where tt.org_id = ho.organization_id
2136: and ho.set_of_books_id = (SELECT glle.ledger_id FROM gl_ledger_le_v glle
2137: WHERE glle.legal_entity_id = xp.legal_entity_id