APPS.PAY_CA_T4_REG dependencies on PAY_CA_ARCHIVE_UTILS

Line 389: pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

385: lv_negative_bal_flag := 'N';
386: if l_report_type in ('PYT4PR','T4_XML') then
387:
388: lv_negative_bal_flag :=
389: pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
390: l_prov_cd,
391: 'JURISDICTION_CODE',
392: 'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
393: end if;

Line 423: lv_sin := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

419: where paa.assignment_action_id = lockingactid;
420:
421: else
422:
423: lv_sin := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
424: 'CAEOY_EMPLOYEE_SIN');
425:
426: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
427: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);

Line 429: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

425:
426: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
427: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);
428:
429: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
430: 'CAEOY_EMPLOYEE_FIRST_NAME');
431:
432: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
433: 'CAEOY_EMPLOYEE_LAST_NAME');

Line 432: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

428:
429: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
430: 'CAEOY_EMPLOYEE_FIRST_NAME');
431:
432: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
433: 'CAEOY_EMPLOYEE_LAST_NAME');
434:
435: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
436:

Line 514: pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

510: lv_negative_bal_flag := 'N';
511: if l_report_type in ('PYT4PR','T4_XML') then
512:
513: lv_negative_bal_flag :=
514: pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
515: l_prov_cd,
516: 'JURISDICTION_CODE',
517: 'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
518: end if;

Line 550: lv_sin := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

546: where paa.assignment_action_id = lockingactid;
547:
548: else
549:
550: lv_sin := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
551: 'CAEOY_EMPLOYEE_SIN');
552:
553: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
554: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);

Line 556: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

552:
553: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
554: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);
555:
556: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
557: 'CAEOY_EMPLOYEE_FIRST_NAME');
558:
559: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
560: 'CAEOY_EMPLOYEE_LAST_NAME');

Line 559: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

555:
556: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
557: 'CAEOY_EMPLOYEE_FIRST_NAME');
558:
559: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
560: 'CAEOY_EMPLOYEE_LAST_NAME');
561:
562: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
563: