[Home] [Help]
587: ppa.effective_date/*,
588: pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
589: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
590: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters) */ --Modified for Bug 14799833
591: FROM pay_assignment_actions paa,
592: pay_payroll_actions ppa
593: where ppa.payroll_action_id = paa.payroll_action_id
594: -- and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
595: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
603: paa.payroll_action_id,
604: paa.assignment_action_id,
605: paa.assignment_id,
606: ppa.effective_date
607: FROM pay_assignment_actions paa,
608: pay_payroll_actions ppa
609: where ppa.payroll_action_id = paa.payroll_action_id
610: and paa.assignment_action_id = act_id--pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
611: and ppa.report_type ='YREND'
622: and ppa.action_status = 'P';
623:
624: CURSOR c_get_yepp_act_id IS
625: /* SELECT AA1.assignment_action_id
626: FROM pay_assignment_actions AA,
627: pay_payroll_actions PA,
628: pay_assignment_actions AA1,
629: pay_payroll_actions PA1
630: WHERE AA.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
624: CURSOR c_get_yepp_act_id IS
625: /* SELECT AA1.assignment_action_id
626: FROM pay_assignment_actions AA,
627: pay_payroll_actions PA,
628: pay_assignment_actions AA1,
629: pay_payroll_actions PA1
630: WHERE AA.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
631: AND AA.payroll_action_id = PA.payroll_action_id
632: AND AA.tax_unit_id = AA1.tax_unit_id
1342: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 50);
1343: else
1344: --Modified for the Bug 15944697
1345: p_sqlstr := 'SELECT DISTINCT to_number(paa.serial_number)
1346: FROM pay_assignment_actions paa,
1347: pay_payroll_actions ppa,
1348: per_all_assignments_f paf,
1349: pay_payroll_actions ppa1,
1350: pay_us_asg_reporting puar,
1514: that are created. */
1515:
1516: l_payroll_action_created boolean := false;
1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1518: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1519:
1520: /* Variable holding the balance to be tested. */
1521:
1522: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
1529:
1530: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
1531: l_psd_user_entity_id ff_database_items.user_entity_id%type;
1532: l_psd_balance_value number(15,2):=0;
1533: l_aaid pay_assignment_actions.assignment_action_id%type;
1534: l_eff_date date;
1535: l_jurisdiction_code VARCHAR2(30);
1536:
1537: /* Variables used to hold the current values returned within the loop for
1563: ASG.assignment_id assignment_id,
1564: paa.tax_unit_id tax_unit_id,
1565: ppa.effective_date effective_end_date
1566: FROM per_all_assignments_f ASG,
1567: pay_assignment_actions paa,
1568: pay_payroll_actions ppa
1569: WHERE ppa.effective_date between l_period_start
1570: and l_period_end
1571: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1597: ASG.assignment_id assignment_id,
1598: paa.tax_unit_id tax_unit_id,
1599: ppa.effective_date effective_end_date
1600: FROM per_all_assignments_f ASG,
1601: pay_assignment_actions paa,
1602: pay_payroll_actions ppa,
1603: pay_population_ranges ppr
1604: WHERE ppa.effective_date between l_period_start
1605: and l_period_end
1636: paa.tax_unit_id tax_unit_id,
1637: ppa.effective_date effective_end_date,
1638: paa.assignment_action_id act_id
1639: FROM per_all_assignments_f ASG,
1640: pay_assignment_actions paa,
1641: pay_payroll_actions ppa
1642: WHERE ppa.effective_date = l_period_end
1643: and ppa.report_type = 'YREND'
1644: and paa.payroll_action_id = ppa.payroll_action_id
1670: paa.tax_unit_id tax_unit_id,
1671: ppa.effective_date effective_end_date,
1672: paa.assignment_action_id act_id
1673: FROM per_all_assignments_f ASG,
1674: pay_assignment_actions paa,
1675: pay_payroll_actions ppa,
1676: pay_population_ranges ppr
1677: WHERE ppa.effective_date= l_period_end
1678: and ppa.report_type = 'YREND'
1714: SELECT /*+ORDERED*/
1715: PAA.ASSIGNMENT_ACTION_ID,
1716: PPA.EFFECTIVE_DATE
1717: FROM PER_ALL_ASSIGNMENTS_F PAF,
1718: PAY_ASSIGNMENT_ACTIONS PAA,
1719: PAY_PAYROLL_ACTIONS PPA ,
1720: PAY_ACTION_CLASSIFICATIONS PAC
1721: WHERE PAF.PERSON_ID = l_person_id
1722: AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
1981: --
1982: -- Create the assignment action to represnt the person / tax unit
1983: -- combination.
1984: --
1985: select pay_assignment_actions_s.nextval
1986: into lockingactid
1987: from dual;
1988: hr_utility.set_location ('action_creation',8);
1989:
1993: WHERE payroll_action_id = p_pactid;
1994: hr_utility.trace('In action_creation, l_transfer_gre_id= '||l_transfer_gre_id);*/
1995:
1996: hr_utility.set_location ('action_creation',9);
1997: -- insert into pay_assignment_actions.
1998:
1999: hr_utility.trace('In action_creation, lockingactid= '||lockingactid);
2000: hr_utility.trace('In action_creation, l_assignment_id= '||l_assignment_id);
2001: hr_utility.trace('In action_creation, p_pactid= '||p_pactid);
2007:
2008: hr_utility.set_location ('action_creation',10);
2009:
2010: -- Addded for Bug 14640336
2011: update pay_assignment_actions
2012: set serial_number=l_person_id
2013: where assignment_action_id=lockingactid;
2014:
2015: hr_utility.set_location ('action_creation',11);
2617: ln_balance_type_id pay_balance_types.balance_type_id%type;
2618:
2619: cursor c_get_min_chunk is
2620: select min(paa.chunk_number)
2621: from pay_assignment_actions paa
2622: where paa.payroll_action_id = p_payroll_action_id;
2623:
2624:
2625: cursor c_get_psd_balances is
2788: l_period_start DATE;
2789: l_period_end DATE;
2790: l_tax_coll_dist_code VARCHAR2(2);
2791:
2792: l_aaid pay_assignment_actions.assignment_action_id%type;
2793: l_asgid pay_assignment_actions.assignment_id%type;
2794: l_eff_date date;
2795: l_date_earned date;
2796: l_taxunitid pay_assignment_actions.tax_unit_id%type;
2789: l_period_end DATE;
2790: l_tax_coll_dist_code VARCHAR2(2);
2791:
2792: l_aaid pay_assignment_actions.assignment_action_id%type;
2793: l_asgid pay_assignment_actions.assignment_id%type;
2794: l_eff_date date;
2795: l_date_earned date;
2796: l_taxunitid pay_assignment_actions.tax_unit_id%type;
2797: l_chunk number;
2792: l_aaid pay_assignment_actions.assignment_action_id%type;
2793: l_asgid pay_assignment_actions.assignment_id%type;
2794: l_eff_date date;
2795: l_date_earned date;
2796: l_taxunitid pay_assignment_actions.tax_unit_id%type;
2797: l_chunk number;
2798: l_payroll_action_id number;
2799: l_context_no number := 60;
2800: l_count number := 0;
2882: PAA.ASSIGNMENT_ACTION_ID,
2883: PPA.EFFECTIVE_DATE
2884: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2885: PER_ALL_ASSIGNMENTS_F PAF ,
2886: PAY_ASSIGNMENT_ACTIONS PAA,
2887: PAY_PAYROLL_ACTIONS PPA ,
2888: PAY_ACTION_CLASSIFICATIONS PAC
2889: WHERE PAF1.ASSIGNMENT_ID = p_assignment_id
2890: AND PAF.PERSON_ID = PAF1.PERSON_ID
2941: l_date_earned,
2942: l_taxunitid,
2943: l_chunk,
2944: l_payroll_action_id
2945: FROM pay_assignment_actions aa
2946: WHERE aa.assignment_action_id = p_assactid;
2947:
2948: hr_utility.trace('l_asgid is : ' || to_char(l_asgid));
2949: hr_utility.trace('l_date_earned is : ' || to_char(l_date_earned));
2998: where assignment_id=l_asgid;*/
2999:
3000: --Modified for the Bug 14690909
3001: select serial_number into l_person_id
3002: from pay_assignment_actions
3003: where assignment_action_id=p_assactid;
3004:
3005: -- Modified for Bug 14640336
3006: open c_get_jurisdiction( l_person_id, l_taxunitid );