DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 78: pay_all_payrolls_f pp,

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