DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 107: hr_organization_information hoi

103: is
104: select /*+ ORDERED */
105: nvl(nvl(pp.prl_information1, hoi.org_information2),'CTR_EE')
106: from pay_all_payrolls_f pp,
107: hr_organization_information hoi
108: where pp.payroll_id = p_payroll_id
109: and p_effective_date
110: between pp.effective_start_date and pp.effective_end_date
111: and hoi.organization_id(+) = pp.business_group_id