APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PAY_CA_ARCHIVE_UTILS

Line 1002: lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,

998: end if;
999:
1000: lv_negative_bal_flag := 'N';
1001:
1002: lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,
1003: lv_prov_of_emp,
1004: 'JURISDICTION_CODE',
1005: 'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
1006:

Line 1071: lv_sin := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,

1067: end if;
1068:
1069: else
1070:
1071: lv_sin := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,
1072: 'CAEOY_EMPLOYEE_SIN');
1073:
1074: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
1075: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);

Line 1077: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,

1073:
1074: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
1075: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);
1076:
1077: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,
1078: 'CAEOY_EMPLOYEE_FIRST_NAME');
1079:
1080: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,
1081: 'CAEOY_EMPLOYEE_LAST_NAME');

Line 1080: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,

1076:
1077: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,
1078: 'CAEOY_EMPLOYEE_FIRST_NAME');
1079:
1080: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_asg_act_to_lock,
1081: 'CAEOY_EMPLOYEE_LAST_NAME');
1082:
1083: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
1084: