DBA Data[Home] [Help]

APPS.PAY_AE_SOE dependencies on HR_ORGANIZATION_INFORMATION

Line 151: , hr_organization_information oi

147: , pay_bal_attribute_definitions bad
148: , pay_defined_balances db
149: , pay_balance_dimensions bd
150: , pay_balance_types_tl bt
151: , hr_organization_information oi
152: , pay_balance_types pbt
153: , hr_lookups hl
154: where bad.attribute_name = p_balance_attribute
155: and ( bad.BUSINESS_GROUP_ID IS NULL

Line 229: FROM HR_ORGANIZATION_INFORMATION

225: AND trunc(l_effective_date,'MM') between trunc(person.effective_start_date,'MM') and person.effective_end_date;
226: --
227: cursor getLocalNat IS
228: SELECT org_information1
229: FROM HR_ORGANIZATION_INFORMATION
230: WHERE ORG_INFORMATION_CONTEXT = 'AE_BG_DETAILS'
231: AND ORGANIZATION_ID = l_business_group_id;
232: --
233: