eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_ZA_TAX_REG dependencies on PAY_ZA_TAX_REGISTERS

Line 97: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;

93:
94: ------------------
95: -- Package Globals
96: ------------------
97: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
98: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
99: g_start_period_id per_time_periods.time_period_id%TYPE;
100: g_end_period_id per_time_periods.time_period_id%TYPE;
101: g_period_num per_time_periods.period_num%TYPE;

Line 1001: pay_za_tax_registers tr

997: IS
998: SELECT
999: count(max(tr.person_id))
1000: FROM
1001: pay_za_tax_registers tr
1002: GROUP BY
1003: tr.person_id;
1004:
1005: ------------

Line 1042: pay_za_tax_registers tr

1038: IS
1039: SELECT
1040: count(max(tr.assignment_id))
1041: FROM
1042: pay_za_tax_registers tr
1043: GROUP BY
1044: tr.assignment_id;
1045:
1046: ------------

Line 1212: pay_za_tax_registers_s.nextval

1208: -------------------------------------------------------------------------------
1209: hr_utility.set_location('py_za_tax_reg.set_globals',1);
1210: --
1211: SELECT
1212: pay_za_tax_registers_s.nextval
1213: INTO
1214: g_tax_register_id
1215: FROM
1216: dual;

Line 1261: p_full_name IN pay_za_tax_registers.full_name%TYPE

1257: -- ins_register
1258: -------------------------------------------------------------------------------
1259: PROCEDURE ins_register (
1260: --
1261: p_full_name IN pay_za_tax_registers.full_name%TYPE
1262: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1263: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1265: , p_age IN pay_za_tax_registers.age%TYPE

Line 1262: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE

1258: -------------------------------------------------------------------------------
1259: PROCEDURE ins_register (
1260: --
1261: p_full_name IN pay_za_tax_registers.full_name%TYPE
1262: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1263: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1265: , p_age IN pay_za_tax_registers.age%TYPE
1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE

Line 1263: , p_person_id IN pay_za_tax_registers.person_id%TYPE

1259: PROCEDURE ins_register (
1260: --
1261: p_full_name IN pay_za_tax_registers.full_name%TYPE
1262: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1263: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1265: , p_age IN pay_za_tax_registers.age%TYPE
1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE

Line 1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE

1260: --
1261: p_full_name IN pay_za_tax_registers.full_name%TYPE
1262: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1263: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1265: , p_age IN pay_za_tax_registers.age%TYPE
1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE

Line 1265: , p_age IN pay_za_tax_registers.age%TYPE

1261: p_full_name IN pay_za_tax_registers.full_name%TYPE
1262: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1263: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1265: , p_age IN pay_za_tax_registers.age%TYPE
1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE

Line 1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE

1262: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1263: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1265: , p_age IN pay_za_tax_registers.age%TYPE
1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE

Line 1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE

1263: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1265: , p_age IN pay_za_tax_registers.age%TYPE
1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE

Line 1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE

1264: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1265: , p_age IN pay_za_tax_registers.age%TYPE
1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE

Line 1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE

1265: , p_age IN pay_za_tax_registers.age%TYPE
1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE

Line 1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE

1266: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE

Line 1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE

1267: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE

Line 1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE

1268: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL

Line 1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE

1269: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL

Line 1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE

1270: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1278: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL

Line 1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE

1271: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1278: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1279: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL

Line 1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL

1272: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1278: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1279: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1280: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL

Line 1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL

1273: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1278: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1279: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1280: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL
1281: )

Line 1278: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL

1274: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1278: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1279: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1280: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL
1281: )
1282: AS

Line 1279: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL

1275: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1278: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1279: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1280: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL
1281: )
1282: AS
1283: ------------

Line 1280: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL

1276: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1277: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1278: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1279: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1280: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL
1281: )
1282: AS
1283: ------------
1284: -- Variables

Line 1292: INSERT INTO pay_za_tax_registers (

1288: BEGIN -- MAIN --
1289: -------------------------------------------------------------------------------
1290: hr_utility.set_location('py_za_tax_reg.ins_register',1);
1291: --
1292: INSERT INTO pay_za_tax_registers (
1293: tax_register_id
1294: , full_name
1295: , employee_number
1296: , person_id

Line 1354: p_id IN pay_za_tax_registers.tax_register_id%TYPE

1350: -------------------------------------------------------------------------------
1351: -- clear_register
1352: -------------------------------------------------------------------------------
1353: PROCEDURE clear_register (
1354: p_id IN pay_za_tax_registers.tax_register_id%TYPE
1355: )
1356: AS
1357: -------------------------------------------------------------------------------
1358: BEGIN -- MAIN --

Line 1364: pay_za_tax_registers ztr

1360: hr_utility.set_location('py_za_tax_reg.clear_register',1);
1361: --
1362: DELETE
1363: FROM
1364: pay_za_tax_registers ztr
1365: WHERE
1366: ztr.tax_register_id = p_id;
1367:
1368: hr_utility.set_location('py_za_tax_reg.clear_register',2);

Line 1382: -- It populates the pay_za_tax_registers table with

1378: -------------------------------------------------------------------------------
1379: -- Procedure pre_process
1380: --
1381: -- The Pre Process procedure called by the ZA Tax Register Report
1382: -- It populates the pay_za_tax_registers table with
1383: -- processed assignment balance value information
1384: -------------------------------------------------------------------------------
1385: PROCEDURE pre_process (
1386: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

Line 1394: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE

1390: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1391: , p_retrieve_ptd IN VARCHAR2
1392: , p_retrieve_mtd IN VARCHAR2
1393: , p_retrieve_ytd IN VARCHAR2
1394: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
1395: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
1396: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
1397: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1398: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE