[Home] [Help]
42: -- for the current Assignment in the same Tax Year
43: cursor other_ass_main is
44: select paa.serial_number, paa.assignment_action_id
45: from pay_assignment_actions paa,
46: pay_payroll_actions ppa
47: where ppa.business_group_id = p_bgid
48: and ppa.report_type = 'ZA_IRP5'
49: and ppa.action_type = 'X'
50: and substr(ppa.legislative_parameters, instr(ppa.legislative_parameters, 'TAX_YEAR') + 9, 4)
64: -- current Assignment in the same Tax Year, and for a specific Time Period ID
65: cursor other_ass_ls(p_period varchar2) is
66: select paa.serial_number, paa.assignment_action_id
67: from pay_assignment_actions paa,
68: pay_payroll_actions ppa,
69: ff_database_items dbi,
70: ff_archive_items arc
71: where ppa.business_group_id = p_bgid
72: and ppa.report_type = 'ZA_IRP5'
124: -- added for 6266019
125:
126: Select decode(count(*), 0 ,'Y', 'N')
127: into l_lump_sum_ind
128: From pay_payroll_actions ppa_arch,
129: pay_assignment_actions paa_arch
130: where paa_arch.assignment_action_id = p_asg_action_id
131: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
132: and paa_arch.assignment_action_id =
339: pai2.action_information26 cert_type, --MAIN/LMPSM
340: pai.action_information_id act_inf_id,
341: pai2.action_information_id act_inf_id2
342: from pay_assignment_actions paa,
343: pay_payroll_actions ppa,
344: pay_action_information pai, --For Employee Info
345: pay_action_information pai2 --For Employee contact info
346: where ppa.business_group_id = p_bgid
347: and ppa.report_type = 'ZA_TYE'