APPS.PAY_CA_EOY_RL1_CANCELLED_PKG dependencies on PAY_CA_ARCHIVE_UTILS

Line 565: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),

561: and ppa.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
562: and decode(ppa.report_type,'RL1PAPERPDF','LATEST','PAYCARL1AMPDF',
563: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
564: 'MODE',ppa.legislative_parameters)) = 'LATEST'
565: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
566: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
567: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'
568: and paf.effective_end_date = (select max(paf.effective_end_date)
569: from per_assignments_f paf

Line 679: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),

675: and ppa.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
676: and decode(ppa.report_type,'RL1PAPERPDF','LATEST','PAYCARL1AMPDF',
677: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
678: 'MODE',ppa.legislative_parameters)) = 'LATEST'
679: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
680: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
681: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'
682: and paf.effective_end_date = (select max(paf.effective_end_date)
683: from per_assignments_f paf

Line 913: lv_negative_bal_flag := nvl(pay_ca_archive_utils.get_archive_value(substr(ln_serial_number,3,14),

909: end if;
910: close check_arch_action_exists;
911:
912: --Negative employeess
913: lv_negative_bal_flag := nvl(pay_ca_archive_utils.get_archive_value(substr(ln_serial_number,3,14),
914: substr(ln_serial_number,1,2),'JURISDICTION_CODE',
915: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS'),'N');
916: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);
917: if lv_negative_bal_flag = 'Y' then