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 98: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

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

Line 104: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

100: g_end_period_id per_time_periods.time_period_id%TYPE;
101: g_period_num per_time_periods.period_num%TYPE;
102: g_period_start_date per_time_periods.start_date%TYPE;
103: g_period_end_date per_time_periods.end_date%TYPE;
104: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
105: g_include_asg VARCHAR2(1);
106: g_retrieve_ptd BOOLEAN;
107: g_retrieve_mtd BOOLEAN;
108: g_retrieve_ytd BOOLEAN;

Line 1160: pay_all_payrolls_f pap

1156: IS
1157: SELECT
1158: pap.payroll_name
1159: FROM
1160: pay_all_payrolls_f pap
1161: WHERE
1162: pap.payroll_id = g_payroll_id
1163: AND g_period_end_date BETWEEN pap.effective_start_date
1164: AND pap.effective_end_date;

Line 1193: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

1189: -------------------------------------------------------------------------------
1190: -- set_globals
1191: -------------------------------------------------------------------------------
1192: PROCEDURE set_globals (
1193: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1194: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1195: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1196: , p_include IN VARCHAR2
1197: , p_retrieve_ptd IN VARCHAR2

Line 1386: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

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
1387: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1388: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1389: , p_include IN VARCHAR2
1390: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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

Line 1412: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE

1408: -- returning the maximum assignment action
1409: -----------------------------------------------------------------
1410: -- Bug 5330452
1411: CURSOR csr_processed_assignments (
1412: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1413: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1414: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1415: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
1416: )