DBA Data[Home] [Help]

APPS.PAY_GB_ONLINE_SOE dependencies on HR_ORGANIZATION_INFORMATION

Line 243: , hr_organization_information oi

239: , pay_bal_attribute_definitions bad
240: , pay_defined_balances db
241: , pay_balance_dimensions bd
242: , pay_balance_types_tl bt
243: , hr_organization_information oi
244: where bad.attribute_name = p_balance_attribute
245: and ( bad.BUSINESS_GROUP_ID IS NULL
246: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
247: AND ( bad.LEGISLATION_CODE IS NULL

Line 539: hr_organization_information org

535: select max(org_information8)
536: from pay_payrolls_f p,
537: pay_payroll_actions pact,
538: hr_soft_coding_keyflex flex,
539: hr_organization_information org
540: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
541: and org.org_information_context = 'Tax Details References'
542: and org.org_information1 = flex.segment1
543: and p.business_group_id = org.organization_id