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_ALL_PAYROLLS_F

Line 152: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

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;
156: g_period_start_date per_time_periods.start_date%TYPE;

Line 158: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

154: g_end_period_id per_time_periods.time_period_id%TYPE;
155: g_period_num per_time_periods.period_num%TYPE;
156: g_period_start_date per_time_periods.start_date%TYPE;
157: g_period_end_date per_time_periods.end_date%TYPE;
158: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
159: g_include_asg VARCHAR2(1);
160: g_retrieve_ptd BOOLEAN;
161: g_retrieve_mtd BOOLEAN;
162: g_retrieve_ytd BOOLEAN;

Line 1217: pay_all_payrolls_f pap

1213: IS
1214: SELECT
1215: pap.payroll_name
1216: FROM
1217: pay_all_payrolls_f pap
1218: WHERE
1219: pap.payroll_id = g_payroll_id
1220: AND g_period_end_date BETWEEN pap.effective_start_date
1221: AND pap.effective_end_date;

Line 1250: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

1246: -------------------------------------------------------------------------------
1247: -- set_globals
1248: -------------------------------------------------------------------------------
1249: PROCEDURE set_globals (
1250: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1251: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1252: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1253: , p_include IN VARCHAR2
1254: , p_retrieve_ptd IN VARCHAR2

Line 1466: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

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
1467: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1468: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1469: , p_include IN VARCHAR2
1470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

Line 1475: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%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
1479: , p_tot_employees OUT NOCOPY NUMBER

Line 1493: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

1489: -- returning the maximum assignment action
1490: -----------------------------------------------------------------
1491: -- Bug 5330452
1492: CURSOR csr_processed_assignments (
1493: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1494: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1495: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1496: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
1497: )

Line 2169: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

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
2170: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2171: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2172: , p_include IN VARCHAR2
2173: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

Line 2178: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%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
2182: , p_tot_employees OUT NOCOPY NUMBER

Line 2196: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

2192: -- returning the maximum assignment action
2193: -----------------------------------------------------------------
2194: -- Bug 5330452
2195: CURSOR csr_processed_assignments (
2196: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
2197: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2198: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2199: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
2200: )

Line 2939: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

2935:
2936: -- bug 13444804
2937:
2938: PROCEDURE archive_set_globals (
2939: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
2940: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2941: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2942: , p_include IN VARCHAR2
2943: , p_retrieve_ptd IN VARCHAR2