[Home] [Help]
148: -- archive Box 17A/C balances.
149: -- 31-DEC-2002 pganguly 115.22 2732112 Changed the cursor
150: -- cur_asg_set_person_id, added
151: -- a date join while joining
152: -- per_assignments_f. Added no
153: -- copy for GSCC.
154: -- 06-NOV-2002 ssouresr 115.21 Populated tables in archinit to
155: -- improve performance.
156: -- 04-NOV-2002 pganguly 115.20 Fixed 2375610. Changed cursor
265: str := 'select
266: distinct paf.person_id
267: from
268: hr_assignment_set_amendments hasa,
269: per_assignments_f paf,
270: pay_payroll_actions ppa
271: WHERE
272: hasa.assignment_set_id =
273: pycadar_pkg.get_parameter(''ASSIGNMENT_SET_ID'',ppa.legislative_parameters) and
343: cursor cur_paf is
344: select
345: puc.user_column_name
346: from
347: per_assignments_f paf,
348: hr_soft_coding_keyflex hsck,
349: pay_user_columns puc
350: where
351: paf.assignment_id = p_asg_id and
680: cursor cur_aaid is
681: select paa.assignment_action_id
682: from pay_assignment_actions paa,
683: pay_payroll_actions ppa,
684: per_assignments_f paf
685: where paf.person_id = p_person_id
686: and paf.assignment_id = paa.assignment_id
687: and paa.payroll_action_id = ppa.payroll_action_id
688: and ppa.action_type = 'X'
877: select
878: distinct paf.person_id person_id
879: from
880: hr_assignment_set_amendments hasa,
881: per_assignments_f paf
882: WHERE
883: hasa.assignment_set_id = l_assignment_set_id and
884: hasa.include_or_exclude = 'I' and
885: hasa.assignment_id = paf.assignment_id and
893: is select
894: paf.assignment_id assignment_id,
895: paf.payroll_id payroll_id
896: from
897: per_assignments_f paf
898: where
899: paf.person_id = b_person_id
900: and paf.person_id >= stperson
901: and paf.person_id <= endperson
907: group by
908: paf.assignment_id,
909: paf.payroll_id;
910:
911: cursor cur_gre(p_assignment_id per_assignments_f.assignment_id%type,
912: p_payroll_id per_assignments_f.payroll_id%type,
913: p_effective_date date) is
914: select
915: distinct paa.tax_unit_id gre_id,
908: paf.assignment_id,
909: paf.payroll_id;
910:
911: cursor cur_gre(p_assignment_id per_assignments_f.assignment_id%type,
912: p_payroll_id per_assignments_f.payroll_id%type,
913: p_effective_date date) is
914: select
915: distinct paa.tax_unit_id gre_id,
916: 'T4' gre_type
1014:
1015: cursor cur_employee_hire_date is
1016: select max(service.date_start) hire_date
1017: from per_periods_of_service service,
1018: per_assignments_f asg
1019: -- where asg.assignment_id = l_assignment_id
1020: where asg.person_id = l_person_id
1021: and l_effective_date BETWEEN
1022: asg.effective_start_date
1752: select
1753: paf.person_id person_id
1754: from
1755: pay_assignment_actions paa,
1756: per_assignments_f paf
1757: where
1758: paa.assignment_action_id = p_assignment_action_id and
1759: paa.assignment_id = paf.assignment_id and
1760: l_effective_date between paf.effective_start_date and
1884:
1885: cursor cur_employee_hire_date is
1886: select max(service.date_start) hire_date
1887: from per_periods_of_service service,
1888: per_assignments_f asg
1889: where asg.assignment_id = l_assignment_id
1890: and l_effective_date BETWEEN
1891: asg.effective_start_date
1892: AND asg.effective_end_date
1897: -- as Employer's payroll reference number in ROE.
1898:
1899: cursor cur_asg_number is
1900: select paf.assignment_number asg_number
1901: from per_assignments_f paf
1902: where l_effective_date between paf.effective_start_date
1903: AND paf.effective_end_date
1904: and paf.assignment_id = l_assignment_id;
1905:
2110: max(paa.assignment_action_id)
2111: from
2112: pay_assignment_actions paa,
2113: pay_payroll_actions ppa,
2114: per_assignments_f paf
2115: where
2116: paa.assignment_id = l_assignment_id and
2117: paa.tax_unit_id = p_tax_unit_id and
2118: paa.payroll_action_id = ppa.payroll_action_id and