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 151: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;

147: type code_value_table is table of code_value_rec index by binary_integer;
148: type code_desc_table is table of code_desc index by binary_integer;
149:
150: g_code code_desc_table;
151: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
152: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
153: g_start_period_id per_time_periods.time_period_id%TYPE;
154: g_end_period_id per_time_periods.time_period_id%TYPE;
155: g_period_num per_time_periods.period_num%TYPE;

Line 1058: pay_za_tax_registers tr

1054: IS
1055: SELECT
1056: count(max(tr.person_id))
1057: FROM
1058: pay_za_tax_registers tr
1059: GROUP BY
1060: tr.person_id;
1061:
1062: ------------

Line 1099: pay_za_tax_registers tr

1095: IS
1096: SELECT
1097: count(max(tr.assignment_id))
1098: FROM
1099: pay_za_tax_registers tr
1100: GROUP BY
1101: tr.assignment_id;
1102:
1103: ------------

Line 1291: pay_za_tax_registers_s.nextval

1287: CLOSE csr_tax_year;
1288: -- Bug 13367825
1289:
1290: SELECT
1291: pay_za_tax_registers_s.nextval
1292: INTO
1293: g_tax_register_id
1294: FROM
1295: dual;

Line 1341: p_full_name IN pay_za_tax_registers.full_name%TYPE

1337: -- ins_register
1338: -------------------------------------------------------------------------------
1339: PROCEDURE ins_register (
1340: --
1341: p_full_name IN pay_za_tax_registers.full_name%TYPE
1342: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1343: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1345: , p_age IN pay_za_tax_registers.age%TYPE

Line 1342: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE

1338: -------------------------------------------------------------------------------
1339: PROCEDURE ins_register (
1340: --
1341: p_full_name IN pay_za_tax_registers.full_name%TYPE
1342: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1343: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1345: , p_age IN pay_za_tax_registers.age%TYPE
1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE

Line 1343: , p_person_id IN pay_za_tax_registers.person_id%TYPE

1339: PROCEDURE ins_register (
1340: --
1341: p_full_name IN pay_za_tax_registers.full_name%TYPE
1342: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1343: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1345: , p_age IN pay_za_tax_registers.age%TYPE
1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE

Line 1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE

1340: --
1341: p_full_name IN pay_za_tax_registers.full_name%TYPE
1342: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1343: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1345: , p_age IN pay_za_tax_registers.age%TYPE
1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE

Line 1345: , p_age IN pay_za_tax_registers.age%TYPE

1341: p_full_name IN pay_za_tax_registers.full_name%TYPE
1342: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1343: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1345: , p_age IN pay_za_tax_registers.age%TYPE
1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE

Line 1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE

1342: , p_employee_number IN pay_za_tax_registers.employee_number%TYPE
1343: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1345: , p_age IN pay_za_tax_registers.age%TYPE
1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE

Line 1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE

1343: , p_person_id IN pay_za_tax_registers.person_id%TYPE
1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1345: , p_age IN pay_za_tax_registers.age%TYPE
1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE

Line 1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE

1344: , p_date_of_birth IN pay_za_tax_registers.date_of_birth%TYPE
1345: , p_age IN pay_za_tax_registers.age%TYPE
1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE

Line 1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE

1345: , p_age IN pay_za_tax_registers.age%TYPE
1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE

Line 1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE

1346: , p_tax_reference_no IN pay_za_tax_registers.tax_reference_no%TYPE
1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE

Line 1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE

1347: , p_cmpy_tax_reference_no IN pay_za_tax_registers.cmpy_tax_reference_no%TYPE
1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE

Line 1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE

1348: , p_tax_status IN pay_za_tax_registers.tax_status%TYPE
1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL

Line 1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE

1349: , p_tax_directive_value IN pay_za_tax_registers.tax_directive_value%TYPE
1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1357: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL

Line 1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE

1350: , p_days_worked IN pay_za_tax_registers.days_worked%TYPE
1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1357: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1358: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL

Line 1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE

1351: , p_assignment_id IN pay_za_tax_registers.assignment_id%TYPE
1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1357: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1358: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1359: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL

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

1352: , p_assignment_action_id IN pay_za_tax_registers.assignment_action_id%TYPE
1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1357: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1358: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1359: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1360: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL

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

1353: , p_assignment_number IN pay_za_tax_registers.assignment_number%TYPE
1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1357: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1358: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1359: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1360: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL
1361: )

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

1354: , p_assignment_start_date IN pay_za_tax_registers.assignment_start_date%TYPE
1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1357: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1358: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1359: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1360: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL
1361: )
1362: AS

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

1355: , p_assignment_end_date IN pay_za_tax_registers.assignment_end_date%TYPE
1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1357: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1358: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1359: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1360: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL
1361: )
1362: AS
1363: ------------

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

1356: , p_bal_name IN pay_za_tax_registers.bal_name%TYPE DEFAULT NULL
1357: , p_bal_code IN pay_za_tax_registers.bal_code%TYPE DEFAULT NULL
1358: , p_tot_ptd IN pay_za_tax_registers.tot_ptd%TYPE DEFAULT NULL
1359: , p_tot_mtd IN pay_za_tax_registers.tot_mtd%TYPE DEFAULT NULL
1360: , p_tot_ytd IN pay_za_tax_registers.tot_ytd%TYPE DEFAULT NULL
1361: )
1362: AS
1363: ------------
1364: -- Variables

Line 1372: INSERT INTO pay_za_tax_registers (

1368: BEGIN -- MAIN --
1369: -------------------------------------------------------------------------------
1370: hr_utility.set_location('py_za_tax_reg.ins_register',1);
1371: --
1372: INSERT INTO pay_za_tax_registers (
1373: tax_register_id
1374: , full_name
1375: , employee_number
1376: , person_id

Line 1434: p_id IN pay_za_tax_registers.tax_register_id%TYPE

1430: -------------------------------------------------------------------------------
1431: -- clear_register
1432: -------------------------------------------------------------------------------
1433: PROCEDURE clear_register (
1434: p_id IN pay_za_tax_registers.tax_register_id%TYPE
1435: )
1436: AS
1437: -------------------------------------------------------------------------------
1438: BEGIN -- MAIN --

Line 1444: pay_za_tax_registers ztr

1440: hr_utility.set_location('py_za_tax_reg.clear_register',1);
1441: --
1442: DELETE
1443: FROM
1444: pay_za_tax_registers ztr
1445: WHERE
1446: ztr.tax_register_id = p_id;
1447:
1448: hr_utility.set_location('py_za_tax_reg.clear_register',2);

Line 1462: -- It populates the pay_za_tax_registers table with

1458: -------------------------------------------------------------------------------
1459: -- Procedure pre_process
1460: --
1461: -- The Pre Process procedure called by the ZA Tax Register Report
1462: -- It populates the pay_za_tax_registers table with
1463: -- processed assignment balance value information
1464: -------------------------------------------------------------------------------
1465: PROCEDURE pre_process (
1466: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

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

1470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1471: , p_retrieve_ptd IN VARCHAR2
1472: , p_retrieve_mtd IN VARCHAR2
1473: , p_retrieve_ytd IN VARCHAR2
1474: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
1475: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
1476: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
1477: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1478: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE

Line 2165: -- It populates the pay_za_tax_registers table with

2161: -------------------------------------------------------------------------------
2162: -- Procedure pre_process to be used from tax year 2010 onwards
2163: --
2164: -- The Pre Process procedure called by the ZA Tax Register Report
2165: -- It populates the pay_za_tax_registers table with
2166: -- processed assignment balance value information
2167: -------------------------------------------------------------------------------
2168: PROCEDURE pre_process_01032009 (
2169: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

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

2173: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2174: , p_retrieve_ptd IN VARCHAR2
2175: , p_retrieve_mtd IN VARCHAR2
2176: , p_retrieve_ytd IN VARCHAR2
2177: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
2178: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
2179: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
2180: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
2181: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE