[Home] [Help]
152: -- archive Box 17A/C balances.
153: -- 31-DEC-2002 pganguly 115.22 2732112 Changed the cursor
154: -- cur_asg_set_person_id, added
155: -- a date join while joining
156: -- per_assignments_f. Added no
157: -- copy for GSCC.
158: -- 06-NOV-2002 ssouresr 115.21 Populated tables in archinit to
159: -- improve performance.
160: -- 04-NOV-2002 pganguly 115.20 Fixed 2375610. Changed cursor
269: str := 'select
270: distinct paf.person_id
271: from
272: hr_assignment_set_amendments hasa,
273: per_assignments_f paf,
274: pay_payroll_actions ppa
275: WHERE
276: hasa.assignment_set_id =
277: pycadar_pkg.get_parameter(''ASSIGNMENT_SET_ID'',ppa.legislative_parameters) and
347: cursor cur_paf is
348: select
349: puc.user_column_name
350: from
351: per_assignments_f paf,
352: hr_soft_coding_keyflex hsck,
353: pay_user_columns puc
354: where
355: paf.assignment_id = p_asg_id and
684: cursor cur_aaid is
685: select paa.assignment_action_id
686: from pay_assignment_actions paa,
687: pay_payroll_actions ppa,
688: per_assignments_f paf
689: where paf.person_id = p_person_id
690: and paf.assignment_id = paa.assignment_id
691: and paa.payroll_action_id = ppa.payroll_action_id
692: and ppa.action_type = 'X'
881: select
882: distinct paf.person_id person_id
883: from
884: hr_assignment_set_amendments hasa,
885: per_assignments_f paf
886: WHERE
887: hasa.assignment_set_id = l_assignment_set_id and
888: hasa.include_or_exclude = 'I' and
889: hasa.assignment_id = paf.assignment_id and
897: is select
898: paf.assignment_id assignment_id,
899: paf.payroll_id payroll_id
900: from
901: per_assignments_f paf
902: where
903: paf.person_id = b_person_id
904: and paf.person_id >= stperson
905: and paf.person_id <= endperson
911: group by
912: paf.assignment_id,
913: paf.payroll_id;
914:
915: cursor cur_gre(p_assignment_id per_assignments_f.assignment_id%type,
916: p_payroll_id per_assignments_f.payroll_id%type,
917: p_effective_date date) is
918: select
919: distinct paa.tax_unit_id gre_id,
912: paf.assignment_id,
913: paf.payroll_id;
914:
915: cursor cur_gre(p_assignment_id per_assignments_f.assignment_id%type,
916: p_payroll_id per_assignments_f.payroll_id%type,
917: p_effective_date date) is
918: select
919: distinct paa.tax_unit_id gre_id,
920: 'T4' gre_type
1018:
1019: cursor cur_employee_hire_date is
1020: select max(service.date_start) hire_date
1021: from per_periods_of_service service,
1022: per_assignments_f asg
1023: -- where asg.assignment_id = l_assignment_id
1024: where asg.person_id = l_person_id
1025: and l_effective_date BETWEEN
1026: asg.effective_start_date
1756: select
1757: paf.person_id person_id
1758: from
1759: pay_assignment_actions paa,
1760: per_assignments_f paf
1761: where
1762: paa.assignment_action_id = p_assignment_action_id and
1763: paa.assignment_id = paf.assignment_id and
1764: l_effective_date between paf.effective_start_date and
1888:
1889: cursor cur_employee_hire_date is
1890: select max(service.date_start) hire_date
1891: from per_periods_of_service service,
1892: per_assignments_f asg
1893: where asg.assignment_id = l_assignment_id
1894: and l_effective_date BETWEEN
1895: asg.effective_start_date
1896: AND asg.effective_end_date
1901: -- as Employer's payroll reference number in ROE.
1902:
1903: cursor cur_asg_number is
1904: select paf.assignment_number asg_number
1905: from per_assignments_f paf
1906: where l_effective_date between paf.effective_start_date
1907: AND paf.effective_end_date
1908: and paf.assignment_id = l_assignment_id;
1909:
2114: max(paa.assignment_action_id)
2115: from
2116: pay_assignment_actions paa,
2117: pay_payroll_actions ppa,
2118: per_assignments_f paf
2119: where
2120: paa.assignment_id = l_assignment_id and
2121: paa.tax_unit_id = p_tax_unit_id and
2122: paa.payroll_action_id = ppa.payroll_action_id and