DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYLG_PKG dependencies on PAY_CORE_UTILS

Line 451: and ( ppa2.action_type in ('I', 'R', 'Q', 'V') or ( ppa2.action_type ='B' and nvl(pay_core_utils.get_parameter('REPORT_TYPE',ppa2.legislative_parameters),'XYZ') <> 'YEA'))

447: and paa2.assignment_id = paa.assignment_id
448: and paa2.action_sequence < paa.action_sequence
449: and paa2.source_action_id is null
450: and ppa2.payroll_action_id = paa2.payroll_action_id
451: and ( ppa2.action_type in ('I', 'R', 'Q', 'V') or ( ppa2.action_type ='B' and nvl(pay_core_utils.get_parameter('REPORT_TYPE',ppa2.legislative_parameters),'XYZ') <> 'YEA'))
452: and trunc(ppa2.effective_date, 'YYYY') = trunc(ppa.effective_date, 'YYYY')
453: order by paa2.action_sequence desc;
454: -- End of 4261844
455: --