DBA Data[Home] [Help]

APPS.PAY_KW_SOE dependencies on HR_ORGANIZATION_INFORMATION

Line 146: , hr_organization_information oi

142: , pay_bal_attribute_definitions bad
143: , pay_defined_balances db
144: , pay_balance_dimensions bd
145: , pay_balance_types_tl bt
146: , hr_organization_information oi
147: , pay_balance_types pbt
148: , hr_lookups hl
149: where bad.attribute_name = p_balance_attribute
150: and ( bad.BUSINESS_GROUP_ID IS NULL

Line 225: FROM HR_ORGANIZATION_INFORMATION

221: AND trunc(l_effective_date,'MM') between trunc(person.effective_start_date,'MM') and person.effective_end_date;
222: --
223: cursor getLocalNat IS
224: SELECT org_information1
225: FROM HR_ORGANIZATION_INFORMATION
226: WHERE ORG_INFORMATION_CONTEXT = 'KW_BG_DETAILS'
227: AND ORGANIZATION_ID = l_business_group_id;
228: --
229: cursor getSIele IS