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 350: FROM per_assignments_f paf,

346: SELECT paa_arch.assignment_action_id,
347: paa_arch.assignment_id,
348: paa_arch.tax_unit_id,
349: paf.effective_end_date
350: FROM per_assignments_f paf,
351: pay_assignment_actions paa_arch
352: WHERE paa_arch.payroll_action_id = p_eoy_payroll_action_id
353: AND paa_arch.action_status = 'C'
354: AND paf.PERSON_ID = p_per_id

Line 357: from per_assignments_f paf2

353: AND paa_arch.action_status = 'C'
354: AND paf.PERSON_ID = p_per_id
355: AND paa_arch.assignment_id = paf.assignment_id
356: AND paf.effective_start_date = (select max(paf2.effective_start_date)
357: from per_assignments_f paf2
358: where paf2.assignment_id = paf.assignment_id
359: and paf2.effective_start_date <= p_session_date)
360: AND paf.effective_end_date >= p_eoy_start_date
361: AND paf.assignment_type = 'E'

Line 455: FROM per_assignments_f paf,

451: 'SELECT paa_arch.assignment_action_id,
452: paa_arch.assignment_id,
453: paa_arch.tax_unit_id,
454: paf.effective_end_date
455: FROM per_assignments_f paf,
456: pay_assignment_actions paa_arch,
457: pay_population_ranges ppr ';
458:
459: c_actions_where :=

Line 465: from per_assignments_f paf2

461: AND paa_arch.payroll_action_id +0= ' || p_eoy_payroll_action_id || '
462: AND paa_arch.assignment_id = paf.assignment_id
463: AND paf.effective_start_date =
464: (select max(paf2.effective_start_date)
465: from per_assignments_f paf2
466: where paf2.assignment_id = paf.assignment_id
467: and paf2.effective_start_date <= ''' || p_session_date || ''')
468: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
469: AND paf.assignment_type = ''E''

Line 503: FROM per_assignments_f paf,

499: 'SELECT paa_arch.assignment_action_id,
500: paa_arch.assignment_id,
501: paa_arch.tax_unit_id,
502: paf.effective_end_date
503: FROM per_assignments_f paf,
504: pay_assignment_actions paa_arch ';
505:
506: c_actions_where := ' WHERE paa_arch.action_status = ''C''
507: AND paa_arch.payroll_action_id +0= ' || p_eoy_payroll_action_id || '

Line 511: from per_assignments_f paf2

507: AND paa_arch.payroll_action_id +0= ' || p_eoy_payroll_action_id || '
508: AND paa_arch.assignment_id = paf.assignment_id
509: AND paf.effective_start_date =
510: (select max(paf2.effective_start_date)
511: from per_assignments_f paf2
512: where paf2.assignment_id = paf.assignment_id
513: and paf2.effective_start_date <= ''' || p_session_date || ''')
514: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
515: AND paf.assignment_type = ''E''

Line 587: per_assignments_f paf,

583: paa_arch.assignment_id,
584: paa_arch.tax_unit_id,
585: paf.effective_end_date
586: FROM
587: per_assignments_f paf,
588: pay_assignment_actions paa_arch,
589: pay_population_ranges ppr ';
590: c_actions_where := '
591: /* disabling the index for performance reason */

Line 598: from per_assignments_f paf2

594: AND paa_arch.assignment_id = paf.assignment_id
595: AND paf.location_id = ' || p_loc_id || '
596: AND paf.effective_start_date =
597: (select max(paf2.effective_start_date)
598: from per_assignments_f paf2
599: where paf2.assignment_id = paf.assignment_id
600: and paf2.effective_start_date <= ''' || p_session_date || ''')
601: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
602: AND paf.assignment_type = ''E''

Line 615: per_assignments_f paf,

611: paa_arch.assignment_id,
612: paa_arch.tax_unit_id,
613: paf.effective_end_date
614: FROM
615: per_assignments_f paf,
616: pay_assignment_actions paa_arch ';
617: c_actions_where := '
618: /* disabling the index for performance reason */
619: WHERE paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 625: from per_assignments_f paf2

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

Line 704: per_assignments_f paf,

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

Line 715: from per_assignments_f paf2

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

Line 733: per_assignments_f paf,

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

Line 743: from per_assignments_f paf2

739: AND paf.organization_id = ' || p_org_id || '
740: AND paa_arch.assignment_id = paf.assignment_id
741: AND paf.effective_start_date =
742: (select max(paf2.effective_start_date)
743: from per_assignments_f paf2
744: where paf2.assignment_id = paf.assignment_id
745: and paf2.effective_start_date <= ''' || p_session_date || ''')
746: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
747: AND paf.assignment_type = ''E''

Line 817: FROM per_assignments_f paf,

813: c_actions_with_person_sql := 'SELECT paa_arch.assignment_action_id,
814: paa_arch.assignment_id,
815: paa_arch.tax_unit_id,
816: paf.effective_end_date
817: FROM per_assignments_f paf,
818: pay_assignment_actions paa_arch';
819:
820: c_actions_where := '
821: WHERE paa_arch.payroll_action_id = ' || p_eoy_payroll_action_id ||'

Line 826: from per_assignments_f paf2

822: AND paa_arch.action_status = ''C''
823: AND paf.PERSON_ID = '|| p_per_id || '
824: AND paa_arch.assignment_id = paf.assignment_id
825: AND paf.effective_start_date = (select max(paf2.effective_start_date)
826: from per_assignments_f paf2
827: where paf2.assignment_id = paf.assignment_id
828: and paf2.effective_start_date <= ''' ||p_session_date ||''')
829: AND paf.effective_end_date >='''|| p_eoy_start_date || '''
830: AND paf.assignment_type = ''E''

Line 912: FROM per_assignments_f paf,

908: 'SELECT paa_arch.assignment_action_id,
909: paa_arch.assignment_id,
910: paa_arch.tax_unit_id,
911: paf.effective_end_date
912: FROM per_assignments_f paf,
913: pay_assignment_actions paa_arch,
914: pay_population_ranges ppr ';
915: c_actions_where := '
916: WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '

Line 921: from per_assignments_f paf2

917: AND paa_arch.action_status = ''C''
918: AND paa_arch.assignment_id = paf.assignment_id
919: AND paf.effective_start_date =
920: (select max(paf2.effective_start_date)
921: from per_assignments_f paf2
922: where paf2.assignment_id = paf.assignment_id
923: and paf2.effective_start_date <= ''' || p_session_date || ''')
924: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
925: AND paf.assignment_type = ''E''

Line 936: FROM per_assignments_f paf,

932: 'SELECT paa_arch.assignment_action_id,
933: paa_arch.assignment_id,
934: paa_arch.tax_unit_id,
935: paf.effective_end_date
936: FROM per_assignments_f paf,
937: pay_assignment_actions paa_arch ';
938: c_actions_where := '
939: WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '
940: AND paa_arch.action_status = ''C''

Line 944: from per_assignments_f paf2

940: AND paa_arch.action_status = ''C''
941: AND paa_arch.assignment_id = paf.assignment_id
942: AND paf.effective_start_date =
943: (select max(paf2.effective_start_date)
944: from per_assignments_f paf2
945: where paf2.assignment_id = paf.assignment_id
946: and paf2.effective_start_date <= ''' || p_session_date || ''')
947: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
948: AND paf.assignment_type = ''E''

Line 1219: FROM per_assignments_f paf,

1215: 'SELECT paa_arch.assignment_action_id,
1216: paa_arch.assignment_id,
1217: paa_arch.tax_unit_id,
1218: paf.effective_end_date
1219: FROM per_assignments_f paf,
1220: pay_assignment_actions paa_arch,
1221: pay_population_ranges ppr ';
1222: c_actions_where := '
1223: WHERE paa_arch.action_status = ''C''

Line 1227: from per_assignments_f paf2

1223: WHERE paa_arch.action_status = ''C''
1224: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1225: AND paa_arch.assignment_id = paf.assignment_id
1226: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1227: from per_assignments_f paf2
1228: where paf2.assignment_id = paf.assignment_id
1229: and paf2.effective_start_date <= ''' || p_session_date || ''')
1230: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1231: AND paf.assignment_type = ''E''

Line 1247: FROM per_assignments_f paf,

1243: 'SELECT paa_arch.assignment_action_id,
1244: paa_arch.assignment_id,
1245: paa_arch.tax_unit_id,
1246: paf.effective_end_date
1247: FROM per_assignments_f paf,
1248: pay_assignment_actions paa_arch ';
1249: c_actions_where := '
1250: WHERE paa_arch.action_status = ''C''
1251: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 1254: from per_assignments_f paf2

1250: WHERE paa_arch.action_status = ''C''
1251: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1252: AND paa_arch.assignment_id = paf.assignment_id
1253: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1254: from per_assignments_f paf2
1255: where paf2.assignment_id = paf.assignment_id
1256: and paf2.effective_start_date <= ''' || p_session_date || ''')
1257: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1258: AND paf.assignment_type = ''E''

Line 1389: FROM per_assignments_f paf,

1385: SELECT paa_arch.assignment_action_id,
1386: paa_arch.assignment_id,
1387: paa_arch.tax_unit_id,
1388: paf.effective_end_date
1389: FROM per_assignments_f paf,
1390: pay_assignment_actions paa_arch
1391: WHERE paa_arch.payroll_action_id = p_eoy_payroll_action_id
1392: AND paa_arch.action_status = 'C'
1393: AND paf.PERSON_ID = p_per_id

Line 1396: from per_assignments_f paf2

1392: AND paa_arch.action_status = 'C'
1393: AND paf.PERSON_ID = p_per_id
1394: AND paa_arch.assignment_id = paf.assignment_id
1395: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1396: from per_assignments_f paf2
1397: where paf2.assignment_id = paf.assignment_id
1398: and paf2.effective_start_date <= p_session_date)
1399: AND paf.effective_end_date >= p_eoy_start_date
1400: AND paf.assignment_type = 'E'

Line 1506: FROM per_assignments_f paf,

1502: 'SELECT paa_arch.assignment_action_id,
1503: paa_arch.assignment_id,
1504: paa_arch.tax_unit_id,
1505: paf.effective_end_date
1506: FROM per_assignments_f paf,
1507: pay_assignment_actions paa_arch,
1508: pay_population_ranges ppr ';
1509: c_actions_where :=
1510: 'WHERE paa_arch.action_status = ''C''

Line 1514: from per_assignments_f paf2

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

Line 1565: FROM per_assignments_f paf,

1561: 'SELECT paa_arch.assignment_action_id,
1562: paa_arch.assignment_id,
1563: paa_arch.tax_unit_id,
1564: paf.effective_end_date
1565: FROM per_assignments_f paf,
1566: pay_assignment_actions paa_arch ';
1567: c_actions_where :=
1568: 'WHERE paa_arch.action_status = ''C''
1569: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 1572: from per_assignments_f paf2

1568: 'WHERE paa_arch.action_status = ''C''
1569: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
1570: AND paa_arch.assignment_id = paf.assignment_id
1571: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1572: from per_assignments_f paf2
1573: where paf2.assignment_id = paf.assignment_id
1574: and paf2.effective_start_date <= ''' || p_session_date || ''')
1575: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1576: AND paf.assignment_type = ''E''

Line 1661: per_assignments_f paf,

1657: paa_arch.assignment_id,
1658: paa_arch.tax_unit_id,
1659: paf.effective_end_date
1660: FROM
1661: per_assignments_f paf,
1662: pay_assignment_actions paa_arch,
1663: pay_population_ranges ppr
1664: /* disabling the index for performance reason */ ';
1665: c_actions_where :=

Line 1671: from per_assignments_f paf2

1667: AND paa_arch.action_status = ''C''
1668: AND paf.location_id = ' || p_loc_id || '
1669: AND paa_arch.assignment_id = paf.assignment_id
1670: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1671: from per_assignments_f paf2
1672: where paf2.assignment_id = paf.assignment_id
1673: and paf2.effective_start_date <= ''' || p_session_date || ''')
1674: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1675: AND paf.assignment_type = ''E''

Line 1704: per_assignments_f paf,

1700: paa_arch.assignment_id,
1701: paa_arch.tax_unit_id,
1702: paf.effective_end_date
1703: FROM
1704: per_assignments_f paf,
1705: pay_assignment_actions paa_arch
1706: /* disabling the index for performance reason */ ';
1707: c_actions_where :=
1708: 'WHERE paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 1713: from per_assignments_f paf2

1709: AND paa_arch.action_status = ''C''
1710: AND paf.location_id = ' || p_loc_id || '
1711: AND paa_arch.assignment_id = paf.assignment_id
1712: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1713: from per_assignments_f paf2
1714: where paf2.assignment_id = paf.assignment_id
1715: and paf2.effective_start_date <= ''' || p_session_date || ''')
1716: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1717: AND paf.assignment_type = ''E''

Line 1803: per_assignments_f paf,

1799: paa_arch.assignment_id,
1800: paa_arch.tax_unit_id,
1801: paf.effective_end_date
1802: FROM
1803: per_assignments_f paf,
1804: pay_assignment_actions paa_arch,
1805: pay_population_ranges ppr
1806: /* disabling the index for performance reason */ ';
1807: c_actions_where :=

Line 1813: from per_assignments_f paf2

1809: AND paa_arch.action_status = ''C''
1810: AND paf.organization_id = ' || p_org_id || '
1811: AND paa_arch.assignment_id = paf.assignment_id
1812: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1813: from per_assignments_f paf2
1814: where paf2.assignment_id = paf.assignment_id
1815: and paf2.effective_start_date <= ''' || p_session_date || ''')
1816: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1817: AND paf.assignment_type = ''E''

Line 1846: per_assignments_f paf,

1842: paa_arch.assignment_id,
1843: paa_arch.tax_unit_id,
1844: paf.effective_end_date
1845: FROM
1846: per_assignments_f paf,
1847: pay_assignment_actions paa_arch
1848: /* disabling the index for performance reason */ ';
1849: c_actions_where :=
1850: 'WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '

Line 1855: from per_assignments_f paf2

1851: AND paa_arch.action_status = ''C''
1852: AND paf.organization_id = ' || p_org_id || '
1853: AND paa_arch.assignment_id = paf.assignment_id
1854: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1855: from per_assignments_f paf2
1856: where paf2.assignment_id = paf.assignment_id
1857: and paf2.effective_start_date <= ''' || p_session_date || ''')
1858: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1859: AND paf.assignment_type = ''E''

Line 1940: per_assignments_f paf,

1936: paa_arch.assignment_id,
1937: paa_arch.tax_unit_id,
1938: paf.effective_end_date
1939: FROM
1940: per_assignments_f paf,
1941: pay_assignment_actions paa_arch
1942: /* disabling the index for performance reason */ ';
1943: c_actions_where :=
1944: 'WHERE paa_arch.payroll_action_id +0 = ' || p_eoy_payroll_action_id || '

Line 1949: from per_assignments_f paf2

1945: AND paa_arch.action_status = ''C''
1946: AND paf.PERSON_ID = '|| p_per_id || '
1947: AND paa_arch.assignment_id = paf.assignment_id
1948: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1949: from per_assignments_f paf2
1950: where paf2.assignment_id = paf.assignment_id
1951: and paf2.effective_start_date <= ''' || p_session_date || ''')
1952: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1953: AND paf.assignment_type = ''E''

Line 2035: FROM per_assignments_f paf,

2031: 'SELECT paa_arch.assignment_action_id,
2032: paa_arch.assignment_id,
2033: paa_arch.tax_unit_id,
2034: paf.effective_end_date
2035: FROM per_assignments_f paf,
2036: pay_assignment_actions paa_arch,
2037: pay_population_ranges ppr ';
2038: c_actions_where :=
2039: 'WHERE paa_arch.action_status = ''C''

Line 2043: from per_assignments_f paf2

2039: 'WHERE paa_arch.action_status = ''C''
2040: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
2041: AND paa_arch.assignment_id = paf.assignment_id
2042: AND paf.effective_start_date = (select max(paf2.effective_start_date)
2043: from per_assignments_f paf2
2044: where paf2.assignment_id = paf.assignment_id
2045: and paf2.effective_start_date <= ''' || p_session_date || ''')
2046: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
2047: AND paf.assignment_type = ''E''

Line 2080: FROM per_assignments_f paf,

2076: 'SELECT paa_arch.assignment_action_id,
2077: paa_arch.assignment_id,
2078: paa_arch.tax_unit_id,
2079: paf.effective_end_date
2080: FROM per_assignments_f paf,
2081: pay_assignment_actions paa_arch ';
2082: c_actions_where :=
2083: 'WHERE paa_arch.action_status = ''C''
2084: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '

Line 2087: from per_assignments_f paf2

2083: 'WHERE paa_arch.action_status = ''C''
2084: AND paa_arch.payroll_action_id + 0 = ' || p_eoy_payroll_action_id || '
2085: AND paa_arch.assignment_id = paf.assignment_id
2086: AND paf.effective_start_date = (select max(paf2.effective_start_date)
2087: from per_assignments_f paf2
2088: where paf2.assignment_id = paf.assignment_id
2089: and paf2.effective_start_date <= ''' || p_session_date || ''')
2090: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
2091: AND paf.assignment_type = ''E''

Line 2186: l_org_id per_assignments_f.organization_id%type;

2182:
2183: l_session_date date;
2184: l_year number ;
2185: l_gre_id pay_assignment_actions.tax_unit_id%type;
2186: l_org_id per_assignments_f.organization_id%type;
2187: l_loc_id per_assignments_f.location_id%type;
2188: l_per_id per_assignments_f.person_id%type;
2189: l_ssn per_people_f.national_identifier%type;
2190: l_state_code pay_us_states.state_code%type;

Line 2187: l_loc_id per_assignments_f.location_id%type;

2183: l_session_date date;
2184: l_year number ;
2185: l_gre_id pay_assignment_actions.tax_unit_id%type;
2186: l_org_id per_assignments_f.organization_id%type;
2187: l_loc_id per_assignments_f.location_id%type;
2188: l_per_id per_assignments_f.person_id%type;
2189: l_ssn per_people_f.national_identifier%type;
2190: l_state_code pay_us_states.state_code%type;
2191: l_asg_set_id number;

Line 2188: l_per_id per_assignments_f.person_id%type;

2184: l_year number ;
2185: l_gre_id pay_assignment_actions.tax_unit_id%type;
2186: l_org_id per_assignments_f.organization_id%type;
2187: l_loc_id per_assignments_f.location_id%type;
2188: l_per_id per_assignments_f.person_id%type;
2189: l_ssn per_people_f.national_identifier%type;
2190: l_state_code pay_us_states.state_code%type;
2191: l_asg_set_id number;
2192: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

Line 2313: l_org_id per_assignments_f.organization_id%type;

2309:
2310: l_dt date;
2311: l_year number ;
2312: l_gre_id pay_assignment_actions.tax_unit_id%type;
2313: l_org_id per_assignments_f.organization_id%type;
2314: l_loc_id per_assignments_f.location_id%type;
2315: l_per_id per_assignments_f.person_id%type;
2316: l_ssn per_people_f.national_identifier%type;
2317: l_state_code pay_us_states.state_code%type;

Line 2314: l_loc_id per_assignments_f.location_id%type;

2310: l_dt date;
2311: l_year number ;
2312: l_gre_id pay_assignment_actions.tax_unit_id%type;
2313: l_org_id per_assignments_f.organization_id%type;
2314: l_loc_id per_assignments_f.location_id%type;
2315: l_per_id per_assignments_f.person_id%type;
2316: l_ssn per_people_f.national_identifier%type;
2317: l_state_code pay_us_states.state_code%type;
2318: l_sort1 varchar2(60);

Line 2315: l_per_id per_assignments_f.person_id%type;

2311: l_year number ;
2312: l_gre_id pay_assignment_actions.tax_unit_id%type;
2313: l_org_id per_assignments_f.organization_id%type;
2314: l_loc_id per_assignments_f.location_id%type;
2315: l_per_id per_assignments_f.person_id%type;
2316: l_ssn per_people_f.national_identifier%type;
2317: l_state_code pay_us_states.state_code%type;
2318: l_sort1 varchar2(60);
2319: l_sort2 varchar2(60);

Line 2388: per_assignments_f paf, pay_assignment_actions mt

2384:
2385: sqlstr :=
2386: 'select mt.rowid
2387: from hr_organization_units hou, hr_locations_all hl, per_periods_of_service pps,
2388: per_assignments_f paf, pay_assignment_actions mt
2389: where mt.payroll_action_id = :pactid and paf.assignment_id = mt.assignment_id
2390: and paf.effective_start_date = (select max(paf2.effective_start_date)
2391: from per_assignments_f paf2
2392: where paf2.assignment_id = paf.assignment_id

Line 2391: from per_assignments_f paf2

2387: from hr_organization_units hou, hr_locations_all hl, per_periods_of_service pps,
2388: per_assignments_f paf, pay_assignment_actions mt
2389: where mt.payroll_action_id = :pactid and paf.assignment_id = mt.assignment_id
2390: and paf.effective_start_date = (select max(paf2.effective_start_date)
2391: from per_assignments_f paf2
2392: where paf2.assignment_id = paf.assignment_id
2393: and paf2.effective_start_date <= to_date(''31-DEC-''||'''||l_year||''',''DD/MM/YYYY''))
2394: and paf.effective_end_date >= to_date(''01-JAN-''||'''||l_year||''',''DD/MM/YYYY'')
2395: and paf.assignment_type = ''E'' and pps.period_of_service_id = paf.period_of_service_id