eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_US_W2_MT dependencies on PER_ASSIGNMENTS_F

Line 150: on per_assignments_f in sort cursor

146: as employees who have both Wages and Taxes
147: withheld should only be reported for the
148: specified locality
149: 115.47 24-JAN-2006 asasthan 4951715 Removed suppression of index
150: on per_assignments_f in sort cursor
151: 115.48 10-AUG-2006 sodhingr 5169849 Changed action_creation for EE report to
152: print the W-2 for terminated EE only
153: 115.49 29-AUG-2006 saurgupt 5169849 Changed the function action_creation_term_ee. Removed
154: condition which checks that the actual_termination_date should

Line 341: FROM per_assignments_f paf,

337: SELECT paa_arch.assignment_action_id,
338: paa_arch.assignment_id,
339: paa_arch.tax_unit_id,
340: paf.effective_end_date
341: FROM per_assignments_f paf,
342: pay_assignment_actions paa_arch
343: WHERE paa_arch.payroll_action_id = p_eoy_payroll_action_id
344: AND paa_arch.action_status = 'C'
345: AND paf.PERSON_ID = p_per_id

Line 348: from per_assignments_f paf2

344: AND paa_arch.action_status = 'C'
345: AND paf.PERSON_ID = p_per_id
346: AND paa_arch.assignment_id = paf.assignment_id
347: AND paf.effective_start_date = (select max(paf2.effective_start_date)
348: from per_assignments_f paf2
349: where paf2.assignment_id = paf.assignment_id
350: and paf2.effective_start_date <= p_session_date)
351: AND paf.effective_end_date >= p_eoy_start_date
352: AND paf.assignment_type = 'E'

Line 446: FROM per_assignments_f paf,

442: 'SELECT paa_arch.assignment_action_id,
443: paa_arch.assignment_id,
444: paa_arch.tax_unit_id,
445: paf.effective_end_date
446: FROM per_assignments_f paf,
447: pay_assignment_actions paa_arch,
448: pay_population_ranges ppr ';
449:
450: c_actions_where :=

Line 456: from per_assignments_f paf2

452: AND paa_arch.payroll_action_id +0= ' || p_eoy_payroll_action_id || '
453: AND paa_arch.assignment_id = paf.assignment_id
454: AND paf.effective_start_date =
455: (select max(paf2.effective_start_date)
456: from per_assignments_f paf2
457: where paf2.assignment_id = paf.assignment_id
458: and paf2.effective_start_date <= ''' || p_session_date || ''')
459: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
460: AND paf.assignment_type = ''E''

Line 494: FROM per_assignments_f paf,

490: 'SELECT paa_arch.assignment_action_id,
491: paa_arch.assignment_id,
492: paa_arch.tax_unit_id,
493: paf.effective_end_date
494: FROM per_assignments_f paf,
495: pay_assignment_actions paa_arch ';
496:
497: c_actions_where := ' WHERE paa_arch.action_status = ''C''
498: AND paa_arch.payroll_action_id +0= ' || p_eoy_payroll_action_id || '

Line 502: from per_assignments_f paf2

498: AND paa_arch.payroll_action_id +0= ' || p_eoy_payroll_action_id || '
499: AND paa_arch.assignment_id = paf.assignment_id
500: AND paf.effective_start_date =
501: (select max(paf2.effective_start_date)
502: from per_assignments_f paf2
503: where paf2.assignment_id = paf.assignment_id
504: and paf2.effective_start_date <= ''' || p_session_date || ''')
505: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
506: AND paf.assignment_type = ''E''

Line 578: per_assignments_f paf,

574: paa_arch.assignment_id,
575: paa_arch.tax_unit_id,
576: paf.effective_end_date
577: FROM per_periods_of_service pps,
578: per_assignments_f paf,
579: pay_assignment_actions paa_arch,
580: pay_population_ranges ppr ';
581: c_actions_where := '
582: /* disabling the index for performance reason */

Line 592: from per_assignments_f paf2

588: and paf.effective_end_date
589: AND paf.location_id = ' || p_loc_id || '
590: AND paf.effective_start_date =
591: (select max(paf2.effective_start_date)
592: from per_assignments_f paf2
593: where paf2.assignment_id = paf.assignment_id
594: and paf2.effective_start_date <= ''' || p_session_date || ''')
595: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
596: AND paf.assignment_type = ''E''

Line 610: per_assignments_f paf,

606: paa_arch.assignment_id,
607: paa_arch.tax_unit_id,
608: paf.effective_end_date
609: FROM per_periods_of_service pps,
610: per_assignments_f paf,
611: pay_assignment_actions paa_arch ';
612: c_actions_where := '
613: /* disabling the index for performance reason */
614: WHERE paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 623: from per_assignments_f paf2

619: and paf.effective_end_date
620: AND paf.location_id = ' || p_loc_id || '
621: AND paf.effective_start_date =
622: (select max(paf2.effective_start_date)
623: from per_assignments_f paf2
624: where paf2.assignment_id = paf.assignment_id
625: and paf2.effective_start_date <= ''' || p_session_date || ''' )
626: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
627: AND paf.assignment_type = ''E''

Line 703: per_assignments_f paf,

699: paa_arch.assignment_id,
700: paa_arch.tax_unit_id,
701: paf.effective_end_date
702: FROM per_periods_of_service pps,
703: per_assignments_f paf,
704: pay_assignment_actions paa_arch,
705: pay_population_ranges ppr ';
706: c_actions_where := '
707: /* disabling the index for performance reason */

Line 717: from per_assignments_f paf2

713: AND paf.organization_id = ' || p_org_id || '
714: AND paa_arch.assignment_id = paf.assignment_id
715: AND paf.effective_start_date =
716: (select max(paf2.effective_start_date)
717: from per_assignments_f paf2
718: where paf2.assignment_id = paf.assignment_id
719: and paf2.effective_start_date <= ''' || p_session_date || ''')
720: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
721: AND paf.assignment_type = ''E''

Line 736: per_assignments_f paf,

732: paa_arch.assignment_id,
733: paa_arch.tax_unit_id,
734: paf.effective_end_date
735: FROM per_periods_of_service pps,
736: per_assignments_f paf,
737: pay_assignment_actions paa_arch ';
738: c_actions_where := '
739: /* disabling the index for performance reason */
740: WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '

Line 749: from per_assignments_f paf2

745: AND paf.organization_id = ' || p_org_id || '
746: AND paa_arch.assignment_id = paf.assignment_id
747: AND paf.effective_start_date =
748: (select max(paf2.effective_start_date)
749: from per_assignments_f paf2
750: where paf2.assignment_id = paf.assignment_id
751: and paf2.effective_start_date <= ''' || p_session_date || ''')
752: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
753: AND paf.assignment_type = ''E''

Line 824: FROM per_assignments_f paf,

820: c_actions_with_person_sql := 'SELECT paa_arch.assignment_action_id,
821: paa_arch.assignment_id,
822: paa_arch.tax_unit_id,
823: paf.effective_end_date
824: FROM per_assignments_f paf,
825: pay_assignment_actions paa_arch';
826:
827: c_actions_where := '
828: WHERE paa_arch.payroll_action_id = ' || p_eoy_payroll_action_id ||'

Line 833: from per_assignments_f paf2

829: AND paa_arch.action_status = ''C''
830: AND paf.PERSON_ID = '|| p_per_id || '
831: AND paa_arch.assignment_id = paf.assignment_id
832: AND paf.effective_start_date = (select max(paf2.effective_start_date)
833: from per_assignments_f paf2
834: where paf2.assignment_id = paf.assignment_id
835: and paf2.effective_start_date <= ''' ||p_session_date ||''')
836: AND paf.effective_end_date >='''|| p_eoy_start_date || '''
837: AND paf.assignment_type = ''E''

Line 919: FROM per_assignments_f paf,

915: 'SELECT paa_arch.assignment_action_id,
916: paa_arch.assignment_id,
917: paa_arch.tax_unit_id,
918: paf.effective_end_date
919: FROM per_assignments_f paf,
920: pay_assignment_actions paa_arch,
921: pay_population_ranges ppr ';
922: c_actions_where := '
923: WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '

Line 928: from per_assignments_f paf2

924: AND paa_arch.action_status = ''C''
925: AND paa_arch.assignment_id = paf.assignment_id
926: AND paf.effective_start_date =
927: (select max(paf2.effective_start_date)
928: from per_assignments_f paf2
929: where paf2.assignment_id = paf.assignment_id
930: and paf2.effective_start_date <= ''' || p_session_date || ''')
931: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
932: AND paf.assignment_type = ''E''

Line 943: FROM per_assignments_f paf,

939: 'SELECT paa_arch.assignment_action_id,
940: paa_arch.assignment_id,
941: paa_arch.tax_unit_id,
942: paf.effective_end_date
943: FROM per_assignments_f paf,
944: pay_assignment_actions paa_arch ';
945: c_actions_where := '
946: WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '
947: AND paa_arch.action_status = ''C''

Line 951: from per_assignments_f paf2

947: AND paa_arch.action_status = ''C''
948: AND paa_arch.assignment_id = paf.assignment_id
949: AND paf.effective_start_date =
950: (select max(paf2.effective_start_date)
951: from per_assignments_f paf2
952: where paf2.assignment_id = paf.assignment_id
953: and paf2.effective_start_date <= ''' || p_session_date || ''')
954: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
955: AND paf.assignment_type = ''E''

Line 1226: FROM per_assignments_f paf,

1222: 'SELECT paa_arch.assignment_action_id,
1223: paa_arch.assignment_id,
1224: paa_arch.tax_unit_id,
1225: paf.effective_end_date
1226: FROM per_assignments_f paf,
1227: pay_assignment_actions paa_arch,
1228: pay_population_ranges ppr ';
1229: c_actions_where := '
1230: WHERE paa_arch.action_status = ''C''

Line 1234: from per_assignments_f paf2

1230: WHERE paa_arch.action_status = ''C''
1231: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1232: AND paa_arch.assignment_id = paf.assignment_id
1233: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1234: from per_assignments_f paf2
1235: where paf2.assignment_id = paf.assignment_id
1236: and paf2.effective_start_date <= ''' || p_session_date || ''')
1237: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1238: AND paf.assignment_type = ''E''

Line 1254: FROM per_assignments_f paf,

1250: 'SELECT paa_arch.assignment_action_id,
1251: paa_arch.assignment_id,
1252: paa_arch.tax_unit_id,
1253: paf.effective_end_date
1254: FROM per_assignments_f paf,
1255: pay_assignment_actions paa_arch ';
1256: c_actions_where := '
1257: WHERE paa_arch.action_status = ''C''
1258: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 1261: from per_assignments_f paf2

1257: WHERE paa_arch.action_status = ''C''
1258: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1259: AND paa_arch.assignment_id = paf.assignment_id
1260: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1261: from per_assignments_f paf2
1262: where paf2.assignment_id = paf.assignment_id
1263: and paf2.effective_start_date <= ''' || p_session_date || ''')
1264: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1265: AND paf.assignment_type = ''E''

Line 1395: FROM per_assignments_f paf,

1391: SELECT paa_arch.assignment_action_id,
1392: paa_arch.assignment_id,
1393: paa_arch.tax_unit_id,
1394: paf.effective_end_date
1395: FROM per_assignments_f paf,
1396: pay_assignment_actions paa_arch
1397: WHERE paa_arch.payroll_action_id = p_eoy_payroll_action_id
1398: AND paa_arch.action_status = 'C'
1399: AND paf.PERSON_ID = p_per_id

Line 1402: from per_assignments_f paf2

1398: AND paa_arch.action_status = 'C'
1399: AND paf.PERSON_ID = p_per_id
1400: AND paa_arch.assignment_id = paf.assignment_id
1401: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1402: from per_assignments_f paf2
1403: where paf2.assignment_id = paf.assignment_id
1404: and paf2.effective_start_date <= p_session_date)
1405: AND paf.effective_end_date >= p_eoy_start_date
1406: AND paf.assignment_type = 'E'

Line 1509: FROM per_assignments_f paf,

1505: 'SELECT paa_arch.assignment_action_id,
1506: paa_arch.assignment_id,
1507: paa_arch.tax_unit_id,
1508: paf.effective_end_date
1509: FROM per_assignments_f paf,
1510: pay_assignment_actions paa_arch,
1511: pay_population_ranges ppr
1512: WHERE paa_arch.action_status = ''C''
1513: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 1516: from per_assignments_f paf2

1512: WHERE paa_arch.action_status = ''C''
1513: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1514: AND paa_arch.assignment_id = paf.assignment_id
1515: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1516: from per_assignments_f paf2
1517: where paf2.assignment_id = paf.assignment_id
1518: and paf2.effective_start_date <= ''' || p_session_date || ''')
1519: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1520: AND paf.assignment_type = ''E''

Line 1550: FROM per_assignments_f paf,

1546: 'SELECT paa_arch.assignment_action_id,
1547: paa_arch.assignment_id,
1548: paa_arch.tax_unit_id,
1549: paf.effective_end_date
1550: FROM per_assignments_f paf,
1551: pay_assignment_actions paa_arch
1552: WHERE paa_arch.action_status = ''C''
1553: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1554: AND paa_arch.assignment_id = paf.assignment_id

Line 1556: from per_assignments_f paf2

1552: WHERE paa_arch.action_status = ''C''
1553: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1554: AND paa_arch.assignment_id = paf.assignment_id
1555: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1556: from per_assignments_f paf2
1557: where paf2.assignment_id = paf.assignment_id
1558: and paf2.effective_start_date <= ''' || p_session_date || ''')
1559: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1560: AND paf.assignment_type = ''E''

Line 1633: per_assignments_f paf,

1629: paa_arch.assignment_id,
1630: paa_arch.tax_unit_id,
1631: paf.effective_end_date
1632: FROM per_periods_of_service pps,
1633: per_assignments_f paf,
1634: pay_assignment_actions paa_arch,
1635: pay_population_ranges ppr
1636: /* disabling the index for performance reason */
1637: WHERE paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 1645: from per_assignments_f paf2

1641: and paf.effective_end_date
1642: AND paf.location_id = ' || p_loc_id || '
1643: AND paa_arch.assignment_id = paf.assignment_id
1644: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1645: from per_assignments_f paf2
1646: where paf2.assignment_id = paf.assignment_id
1647: and paf2.effective_start_date <= ''' || p_session_date || ''')
1648: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1649: AND paf.assignment_type = ''E''

Line 1679: per_assignments_f paf,

1675: paa_arch.assignment_id,
1676: paa_arch.tax_unit_id,
1677: paf.effective_end_date
1678: FROM per_periods_of_service pps,
1679: per_assignments_f paf,
1680: pay_assignment_actions paa_arch
1681: /* disabling the index for performance reason */
1682: WHERE paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1683: AND paa_arch.action_status = ''C''

Line 1690: from per_assignments_f paf2

1686: and paf.effective_end_date
1687: AND paf.location_id = ' || p_loc_id || '
1688: AND paa_arch.assignment_id = paf.assignment_id
1689: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1690: from per_assignments_f paf2
1691: where paf2.assignment_id = paf.assignment_id
1692: and paf2.effective_start_date <= ''' || p_session_date || ''')
1693: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1694: AND paf.assignment_type = ''E''

Line 1769: per_assignments_f paf,

1765: paa_arch.assignment_id,
1766: paa_arch.tax_unit_id,
1767: paf.effective_end_date
1768: FROM per_periods_of_service pps,
1769: per_assignments_f paf,
1770: pay_assignment_actions paa_arch,
1771: pay_population_ranges ppr
1772: /* disabling the index for performance reason */
1773: WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '

Line 1781: from per_assignments_f paf2

1777: and paf.effective_end_date
1778: AND paf.organization_id = ' || p_org_id || '
1779: AND paa_arch.assignment_id = paf.assignment_id
1780: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1781: from per_assignments_f paf2
1782: where paf2.assignment_id = paf.assignment_id
1783: and paf2.effective_start_date <= ''' || p_session_date || ''')
1784: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1785: AND paf.assignment_type = ''E''

Line 1815: per_assignments_f paf,

1811: paa_arch.assignment_id,
1812: paa_arch.tax_unit_id,
1813: paf.effective_end_date
1814: FROM per_periods_of_service pps,
1815: per_assignments_f paf,
1816: pay_assignment_actions paa_arch
1817: /* disabling the index for performance reason */
1818: WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '
1819: AND paa_arch.action_status = ''C''

Line 1826: from per_assignments_f paf2

1822: and paf.effective_end_date
1823: AND paf.organization_id = ' || p_org_id || '
1824: AND paa_arch.assignment_id = paf.assignment_id
1825: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1826: from per_assignments_f paf2
1827: where paf2.assignment_id = paf.assignment_id
1828: and paf2.effective_start_date <= ''' || p_session_date || ''')
1829: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1830: AND paf.assignment_type = ''E''

Line 1946: FROM per_assignments_f paf,

1942: 'SELECT paa_arch.assignment_action_id,
1943: paa_arch.assignment_id,
1944: paa_arch.tax_unit_id,
1945: paf.effective_end_date
1946: FROM per_assignments_f paf,
1947: pay_assignment_actions paa_arch,
1948: pay_population_ranges ppr
1949: WHERE paa_arch.action_status = ''C''
1950: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 1953: from per_assignments_f paf2

1949: WHERE paa_arch.action_status = ''C''
1950: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1951: AND paa_arch.assignment_id = paf.assignment_id
1952: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1953: from per_assignments_f paf2
1954: where paf2.assignment_id = paf.assignment_id
1955: and paf2.effective_start_date <= ''' || p_session_date || ''')
1956: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1957: AND paf.assignment_type = ''E''

Line 1990: FROM per_assignments_f paf,

1986: 'SELECT paa_arch.assignment_action_id,
1987: paa_arch.assignment_id,
1988: paa_arch.tax_unit_id,
1989: paf.effective_end_date
1990: FROM per_assignments_f paf,
1991: pay_assignment_actions paa_arch
1992: WHERE paa_arch.action_status = ''C''
1993: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1994: AND paa_arch.assignment_id = paf.assignment_id

Line 1996: from per_assignments_f paf2

1992: WHERE paa_arch.action_status = ''C''
1993: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1994: AND paa_arch.assignment_id = paf.assignment_id
1995: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1996: from per_assignments_f paf2
1997: where paf2.assignment_id = paf.assignment_id
1998: and paf2.effective_start_date <= ''' || p_session_date || ''')
1999: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
2000: AND paf.assignment_type = ''E''

Line 2085: l_org_id per_assignments_f.organization_id%type;

2081:
2082: l_session_date date;
2083: l_year number ;
2084: l_gre_id pay_assignment_actions.tax_unit_id%type;
2085: l_org_id per_assignments_f.organization_id%type;
2086: l_loc_id per_assignments_f.location_id%type;
2087: l_per_id per_assignments_f.person_id%type;
2088: l_ssn per_people_f.national_identifier%type;
2089: l_state_code pay_us_states.state_code%type;

Line 2086: l_loc_id per_assignments_f.location_id%type;

2082: l_session_date date;
2083: l_year number ;
2084: l_gre_id pay_assignment_actions.tax_unit_id%type;
2085: l_org_id per_assignments_f.organization_id%type;
2086: l_loc_id per_assignments_f.location_id%type;
2087: l_per_id per_assignments_f.person_id%type;
2088: l_ssn per_people_f.national_identifier%type;
2089: l_state_code pay_us_states.state_code%type;
2090: l_asg_set_id number;

Line 2087: l_per_id per_assignments_f.person_id%type;

2083: l_year number ;
2084: l_gre_id pay_assignment_actions.tax_unit_id%type;
2085: l_org_id per_assignments_f.organization_id%type;
2086: l_loc_id per_assignments_f.location_id%type;
2087: l_per_id per_assignments_f.person_id%type;
2088: l_ssn per_people_f.national_identifier%type;
2089: l_state_code pay_us_states.state_code%type;
2090: l_asg_set_id number;
2091: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

Line 2212: l_org_id per_assignments_f.organization_id%type;

2208:
2209: l_dt date;
2210: l_year number ;
2211: l_gre_id pay_assignment_actions.tax_unit_id%type;
2212: l_org_id per_assignments_f.organization_id%type;
2213: l_loc_id per_assignments_f.location_id%type;
2214: l_per_id per_assignments_f.person_id%type;
2215: l_ssn per_people_f.national_identifier%type;
2216: l_state_code pay_us_states.state_code%type;

Line 2213: l_loc_id per_assignments_f.location_id%type;

2209: l_dt date;
2210: l_year number ;
2211: l_gre_id pay_assignment_actions.tax_unit_id%type;
2212: l_org_id per_assignments_f.organization_id%type;
2213: l_loc_id per_assignments_f.location_id%type;
2214: l_per_id per_assignments_f.person_id%type;
2215: l_ssn per_people_f.national_identifier%type;
2216: l_state_code pay_us_states.state_code%type;
2217: l_sort1 varchar2(60);

Line 2214: l_per_id per_assignments_f.person_id%type;

2210: l_year number ;
2211: l_gre_id pay_assignment_actions.tax_unit_id%type;
2212: l_org_id per_assignments_f.organization_id%type;
2213: l_loc_id per_assignments_f.location_id%type;
2214: l_per_id per_assignments_f.person_id%type;
2215: l_ssn per_people_f.national_identifier%type;
2216: l_state_code pay_us_states.state_code%type;
2217: l_sort1 varchar2(60);
2218: l_sort2 varchar2(60);

Line 2286: from hr_organization_units hou, hr_locations_all hl, per_periods_of_service pps, per_assignments_f paf,

2282: hr_utility.trace('Beginning of the sort_action cursor');
2283:
2284: sqlstr :=
2285: 'select mt.rowid
2286: from hr_organization_units hou, hr_locations_all hl, per_periods_of_service pps, per_assignments_f paf,
2287: pay_assignment_actions mt where mt.payroll_action_id = :pactid and
2288: paf.assignment_id = mt.assignment_id and paf.effective_start_date = (select max(paf2.effective_start_date)
2289: from per_assignments_f paf2 where paf2.assignment_id = paf.assignment_id
2290: and paf2.effective_start_date <= to_date(''31-DEC-''||'''||l_year||''',''DD/MM/YYYY''))

Line 2289: from per_assignments_f paf2 where paf2.assignment_id = paf.assignment_id

2285: 'select mt.rowid
2286: from hr_organization_units hou, hr_locations_all hl, per_periods_of_service pps, per_assignments_f paf,
2287: pay_assignment_actions mt where mt.payroll_action_id = :pactid and
2288: paf.assignment_id = mt.assignment_id and paf.effective_start_date = (select max(paf2.effective_start_date)
2289: from per_assignments_f paf2 where paf2.assignment_id = paf.assignment_id
2290: and paf2.effective_start_date <= to_date(''31-DEC-''||'''||l_year||''',''DD/MM/YYYY''))
2291: and paf.effective_end_date >= to_date(''01-JAN-''||'''||l_year||''',''DD/MM/YYYY'')
2292: and paf.assignment_type = ''E'' and pps.period_of_service_id = paf.period_of_service_id
2293: and pps.person_id = paf.person_id and hl.location_id = paf.location_id