DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYLG_PKG dependencies on PAY_CORE_UTILS

Line 753: 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'))

749: and paa2.assignment_id = paa.assignment_id
750: and paa2.action_sequence < paa.action_sequence
751: and paa2.source_action_id is null
752: and ppa2.payroll_action_id = paa2.payroll_action_id
753: 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'))
754: and trunc(ppa2.effective_date, 'YYYY') = trunc(ppa.effective_date, 'YYYY')
755: order by paa2.action_sequence desc;
756: -- End of 4261844
757: --