DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 81: pay_all_payrolls_f pp,

77: is
78: select /*+ ORDERED */
79: nvl(nvl(pp.prl_information1, hoi.org_information2),'CTR_EE')
80: from /* Payroll and Business Group details */
81: pay_all_payrolls_f pp,
82: hr_organization_information hoi
83: where pp.payroll_id = g_payroll_id
84: and g_effective_date
85: between pp.effective_start_date and pp.effective_end_date