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.PAY_ZA_TAX_REG_AR dependencies on PER_TIME_PERIODS

Line 28: g_st_period_id per_time_periods.time_period_id%type;

24: g_package constant varchar2(30):= 'pay_za_tax_reg_rep.';
25:
26: -- Legislative Parameters
27: g_payroll_id pay_payrolls_f.payroll_id%type ;
28: g_st_period_id per_time_periods.time_period_id%type;
29: g_end_period_id per_time_periods.time_period_id%type;
30: g_payroll_name pay_payrolls_f.payroll_name%type := null;
31: g_end_period_date per_time_periods.end_date%type;
32: g_inc_all_asg VARCHAR2(1);

Line 29: g_end_period_id per_time_periods.time_period_id%type;

25:
26: -- Legislative Parameters
27: g_payroll_id pay_payrolls_f.payroll_id%type ;
28: g_st_period_id per_time_periods.time_period_id%type;
29: g_end_period_id per_time_periods.time_period_id%type;
30: g_payroll_name pay_payrolls_f.payroll_name%type := null;
31: g_end_period_date per_time_periods.end_date%type;
32: g_inc_all_asg VARCHAR2(1);
33: g_spc_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 31: g_end_period_date per_time_periods.end_date%type;

27: g_payroll_id pay_payrolls_f.payroll_id%type ;
28: g_st_period_id per_time_periods.time_period_id%type;
29: g_end_period_id per_time_periods.time_period_id%type;
30: g_payroll_name pay_payrolls_f.payroll_name%type := null;
31: g_end_period_date per_time_periods.end_date%type;
32: g_inc_all_asg VARCHAR2(1);
33: g_spc_asg_id per_all_assignments_f.assignment_id%TYPE;
34: g_ret_ptd VARCHAR2(1);
35: g_ret_mtd VARCHAR2(1);

Line 44: g_tax_year per_time_periods.prd_information1%type;

40: g_print_det VARCHAR2(1);
41: g_debug VARCHAR2(1);
42: g_legal_entity_id NUMBER;
43:
44: g_tax_year per_time_periods.prd_information1%type;
45:
46:
47: FUNCTION get_parameter(p_parameter_string IN VARCHAR2,
48: p_token IN VARCHAR2) RETURN VARCHAR2

Line 151: , p_period_end_date IN per_time_periods.end_date%TYPE

147: -----------------------------------------------------------------
148: -- TODO Tune this cursor so as to retrive only required onfo
149: CURSOR csr_processed_assignments (
150: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE DEFAULT NULL
151: , p_period_end_date IN per_time_periods.end_date%TYPE
152: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
153: , p_legal_entity_id NUMBER
154: )
155: IS

Line 159: , per_time_periods ptp

155: IS
156: SELECT PAF.assignment_id
157: FROM per_assignments_f PAF
158: , per_assignment_extra_info aei
159: , per_time_periods ptp
160: WHERE PAF.payroll_id = nvl(p_payroll_id, PAF.payroll_id)
161: AND PAF.assignment_id = nvl(p_asg_id, PAF.assignment_id)
162: AND aei.assignment_id = PAF.assignment_id
163: AND aei.aei_information_category = 'ZA_SPECIFIC_INFO'

Line 180: from per_time_periods ptp1

176: where paa3.assignment_id = PAF.assignment_id
177: and paa3.payroll_action_id = ppa2.payroll_action_id
178: and ppa2.action_type IN ('R', 'Q', 'I', 'B', 'V')
179: and ppa2.time_period_id >= (select MIN(ptp1.time_period_id) min_time_period
180: from per_time_periods ptp1
181: where ptp1.payroll_id = PAF.payroll_id
182: and ptp1.prd_information1 = ptp.prd_information1
183: )
184: and ppa2.time_period_id <= ptp.time_period_id

Line 319: l_period_num per_time_periods.period_num%TYPE;

315: l_asg_id pay_assignment_actions.assignment_id%type;
316:
317: l_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
318: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
319: l_period_num per_time_periods.period_num%TYPE;
320: l_period_start_date per_time_periods.start_date%TYPE;
321: l_period_end_date per_time_periods.end_date%TYPE;
322: l_tot_employees NUMBER;
323: l_tot_assignments NUMBER;

Line 320: l_period_start_date per_time_periods.start_date%TYPE;

316:
317: l_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
318: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
319: l_period_num per_time_periods.period_num%TYPE;
320: l_period_start_date per_time_periods.start_date%TYPE;
321: l_period_end_date per_time_periods.end_date%TYPE;
322: l_tot_employees NUMBER;
323: l_tot_assignments NUMBER;
324:

Line 321: l_period_end_date per_time_periods.end_date%TYPE;

317: l_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
318: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
319: l_period_num per_time_periods.period_num%TYPE;
320: l_period_start_date per_time_periods.start_date%TYPE;
321: l_period_end_date per_time_periods.end_date%TYPE;
322: l_tot_employees NUMBER;
323: l_tot_assignments NUMBER;
324:
325: leg_param pay_payroll_actions.legislative_parameters%type;

Line 331: l_pay_advice_date per_time_periods.end_date%type;

327: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
328: l_action_info_id number;
329: l_ovn number;
330: l_qtr_num number;
331: l_pay_advice_date per_time_periods.end_date%type;
332:
333: begin
334: hr_utility.set_location('Entering: '||l_proc,10);
335: hr_utility.set_location('Processing Action ID:'||p_assactid,10);

Line 371: from per_time_periods ptp

367:
368:
369: select ptp.prd_information1,PAF.payroll_id, ptp.time_period_id, ptp.prd_information2, ptp.pay_advice_date
370: into g_tax_year, g_payroll_id, g_end_period_id, l_qtr_num, l_pay_advice_date
371: from per_time_periods ptp
372: ,pay_assignment_actions paa
373: ,per_assignments_f PAF
374: where paa.assignment_action_id = p_assactid
375: and PAF.assignment_id = paa.assignment_id

Line 411: from per_time_periods ptp

407:
408:
409: select MIN(ptp.time_period_id)
410: into g_st_period_id
411: from per_time_periods ptp
412: where ptp.payroll_id = g_payroll_id
413: and ptp.prd_information1 = g_tax_year;
414:
415:

Line 502: , per_time_periods ptp

498: from pay_payroll_actions ppa
499: , pay_assignment_actions paa
500: , pay_action_information pai
501: , pay_all_payrolls_f ppf
502: , per_time_periods ptp
503: where ppa.payroll_action_id = pactid
504: and ppa.action_status = 'C'
505: and paa.payroll_action_id = ppa.payroll_action_id
506: and paa.action_status = 'C'

Line 624: FROM per_time_periods ptp

620: , fnd_date.date_to_displaydate(ptp.end_date)
621: INTO c_period_num
622: ,c_period_start
623: ,c_period_end
624: FROM per_time_periods ptp
625: WHERE ptp.time_period_id = p_end_period_id;
626:
627: */
628: