DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 101: from pay_all_payrolls_f pp,

97: cursor csr_bg_itax_dpnt_ref_type
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