[Home] [Help]
145: eoy_all_range as GRE is manadatory
146: parameter for year end process so
147: these cursors will never be used.
148: Also, changed cursor eoy_gre_range
149: to join with pay_us_asg_reporting
150: instead of hr_soft_coding_keyflex.
151: This will ensure that assignments
152: are picked up year end preprocess
153: even if GRE is no longer valid for
364: 04-DEC-1998 vmehta 40.14 750802 Changed the cursors/logic to
365: pick up people who live in
366: California for the California SQWL.
367: 29-NOV-1998 nbristow 40.13 Changes to the SQWL code,
368: now using pay_us_asg_reporting.
369: 25-Sep-1998 vmehta 40.5 Changed the range cursor and
370: the assignment_action creation
371: cursors to support Louisiana
372: Quality Jobs Program Reporting.
3877:
3878: /* cursor c_get_jurisdiction (cp_assignment_id number
3879: ,cp_tax_unit_id number) is
3880: select distinct puar.jurisdiction_code
3881: from pay_us_asg_reporting puar
3882: where puar.assignment_id = cp_assignment_id
3883: and puar.tax_unit_id = cp_tax_unit_id
3884: and length(puar.jurisdiction_code)=16
3885: and substr(puar.jurisdiction_code,1,2) = '39';--picking up only PA related Jurisdiction codes. */
3888:
3889: cursor c_get_jurisdiction (cp_person_id number
3890: ,cp_tax_unit_id number) is
3891: select distinct puar.jurisdiction_code
3892: from pay_us_asg_reporting puar,
3893: per_all_Assignments_f paf
3894: where puar.assignment_id = paf.assignment_id
3895: and paf.person_id = cp_person_id
3896: and puar.tax_unit_id = cp_tax_unit_id
5317: hr_utility.trace('In eoy_range_cursor');
5318:
5319: eoy_gre_range := 'SELECT distinct ASG.person_id
5320: FROM per_all_assignments_f ASG,
5321: pay_us_asg_reporting puar,
5322: pay_payroll_actions PPA
5323: WHERE PPA.payroll_action_id = :payroll_action_id
5324: AND puar.tax_unit_id = substr(legislative_parameters,
5325: instr(legislative_parameters,''TRANSFER_GRE='')+ length(''TRANSFER_GRE=''))