DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 102: hr_organization_information hoi

98: is
99: select /*+ ORDERED */
100: nvl(nvl(pp.prl_information1, hoi.org_information2),'CTR_EE')
101: from pay_all_payrolls_f pp,
102: hr_organization_information hoi
103: where pp.payroll_id = p_payroll_id
104: and p_effective_date
105: between pp.effective_start_date and pp.effective_end_date
106: and hoi.organization_id(+) = pp.business_group_id