APPS.PAY_CA_T4_REG dependencies on PAY_CA_ARCHIVE_UTILS

Line 843: pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

839: lv_negative_bal_flag := 'N';
840: if l_report_type in ('PYT4PR','T4_XML') then
841:
842: lv_negative_bal_flag :=
843: pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
844: l_prov_cd,
845: 'JURISDICTION_CODE',
846: 'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
847: end if;

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

885: end if;
886:
887: else
888:
889: lv_sin := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
890: 'CAEOY_EMPLOYEE_SIN');
891:
892: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
893: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);

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

891:
892: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
893: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);
894:
895: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
896: 'CAEOY_EMPLOYEE_FIRST_NAME');
897:
898: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
899: 'CAEOY_EMPLOYEE_LAST_NAME');

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

894:
895: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
896: 'CAEOY_EMPLOYEE_FIRST_NAME');
897:
898: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
899: 'CAEOY_EMPLOYEE_LAST_NAME');
900:
901: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
902:

Line 1140: pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,

1136: lv_negative_bal_flag := 'N';
1137: if l_report_type in ('PYT4PR','T4_XML') then
1138:
1139: lv_negative_bal_flag :=
1140: pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
1141: l_prov_cd,
1142: 'JURISDICTION_CODE',
1143: 'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
1144: end if;

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

1180: end if;
1181:
1182: else
1183:
1184: lv_sin := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
1185: 'CAEOY_EMPLOYEE_SIN');
1186:
1187: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
1188: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);

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

1186:
1187: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
1188: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);
1189:
1190: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
1191: 'CAEOY_EMPLOYEE_FIRST_NAME');
1192:
1193: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
1194: 'CAEOY_EMPLOYEE_LAST_NAME');

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

1189:
1190: lv_employee_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
1191: 'CAEOY_EMPLOYEE_FIRST_NAME');
1192:
1193: lv_employee_last_name := pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id,
1194: 'CAEOY_EMPLOYEE_LAST_NAME');
1195:
1196: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
1197: