DBA Data[Home] [Help]

APPS.PAY_GB_ONLINE_SOE dependencies on HR_ORGANIZATION_INFORMATION

Line 238: , hr_organization_information oi

234: , pay_bal_attribute_definitions bad
235: , pay_defined_balances db
236: , pay_balance_dimensions bd
237: , pay_balance_types_tl bt
238: , hr_organization_information oi
239: where bad.attribute_name = p_balance_attribute
240: and ( bad.BUSINESS_GROUP_ID IS NULL
241: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
242: AND ( bad.LEGISLATION_CODE IS NULL

Line 534: hr_organization_information org

530: select max(org_information8)
531: from pay_payrolls_f p,
532: pay_payroll_actions pact,
533: hr_soft_coding_keyflex flex,
534: hr_organization_information org
535: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
536: and org.org_information_context = 'Tax Details References'
537: and org.org_information1 = flex.segment1
538: and p.business_group_id = org.organization_id