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.PAY_US_EMP_DT_TAX_VAL dependencies on PER_ASSIGNMENTS_F

Line 78: per_assignments_f paf

74: pus.state_code
75: FROM pay_us_states pus,
76: pay_us_states pus1,
77: per_addresses pa,
78: per_assignments_f paf
79: WHERE paf.assignment_id = p_assignment_id
80: AND p_session_date BETWEEN paf.effective_start_date
81: AND paf.effective_end_date
82: AND paf.person_id = pa.person_id

Line 100: per_assignments_f paf

96: pay_us_states pus1,
97: pay_us_counties puc,
98: pay_us_counties puc1,
99: per_addresses pa,
100: per_assignments_f paf
101: WHERE paf.assignment_id = p_assignment_id
102: AND p_session_date BETWEEN paf.effective_start_date
103: AND paf.effective_end_date
104: AND paf.person_id = pa.person_id

Line 131: per_assignments_f paf

127: pay_us_counties puc1,
128: pay_us_city_names pucy,
129: pay_us_city_names pucy1,
130: per_addresses pa,
131: per_assignments_f paf
132: WHERE paf.assignment_id = p_assignment_id
133: AND p_session_date BETWEEN paf.effective_start_date
134: AND paf.effective_end_date
135: AND paf.person_id = pa.person_id

Line 283: per_assignments_f paf

279: pay_us_states pus1,
280: hr_locations hl,
281: hr_locations hl1,
282: hr_soft_coding_keyflex hscf,
283: per_assignments_f paf
284: WHERE paf.assignment_id = p_assignment_id
285: AND p_session_date BETWEEN paf.effective_start_date
286: AND paf.effective_end_date
287: AND hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 308: per_assignments_f paf

304: pay_us_counties puc1,
305: hr_locations hl,
306: hr_locations hl1,
307: hr_soft_coding_keyflex hscf,
308: per_assignments_f paf
309: WHERE paf.assignment_id = p_assignment_id
310: AND p_session_date BETWEEN paf.effective_start_date
311: AND paf.effective_end_date
312: AND hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 341: per_assignments_f paf

337: pay_us_city_names pucy1,
338: hr_locations hl,
339: hr_locations hl1,
340: hr_soft_coding_keyflex hscf,
341: per_assignments_f paf
342: WHERE paf.assignment_id = p_assignment_id
343: AND p_session_date BETWEEN paf.effective_start_date
344: AND paf.effective_end_date
345: AND hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 516: from PER_ASSIGNMENTS_F paf

512: l_payroll_installed boolean := FALSE;
513:
514: cursor csr_chk_loc_change is
515: select paf.location_id
516: from PER_ASSIGNMENTS_F paf
517: where paf.assignment_id = p_assignment_id
518: and p_session_date between paf.effective_start_date
519: and paf.effective_end_date;
520:

Line 523: from per_assignments_f paf1

519: and paf.effective_end_date;
520:
521: cursor csr_get_next_locations is
522: select paf1.location_id
523: from per_assignments_f paf1
524: where paf1.assignment_id = p_assignment_id
525: and paf1.effective_start_date > p_effective_end_date
526: order by paf1.effective_start_date;
527:

Line 532: from per_assignments_f paf

528: cursor csr_chk_payroll is
529: /* 11.5.10 changes performance modification. original code
530: commented out below. */
531: select 1
532: from per_assignments_f paf
533: ,pay_payroll_actions ppa
534: ,pay_assignment_actions paa
535: where paf.assignment_id = p_assignment_id
536: and ppa.payroll_id = paf.payroll_id

Line 755: PER_ASSIGNMENTS_F paf

751:
752: CURSOR csr_check_state is
753: select 1
754: from HR_LOCATIONS hrl,
755: PER_ASSIGNMENTS_F paf
756: where paf.assignment_id = p_assignment_id
757: and hrl.location_id = paf.location_id
758: and exists (select null
759: from PAY_US_STATES pus

Line 767: PER_ASSIGNMENTS_F paf

763: CURSOR csr_check_ovrd_state is
764: select 1
765: from HR_LOCATIONS hrl,
766: HR_SOFT_CODING_KEYFLEX hscf,
767: PER_ASSIGNMENTS_F paf
768: where paf.assignment_id = p_assignment_id
769: and hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
770: and hrl.location_id = hscf.segment18
771: and exists (select null

Line 782: PER_ASSIGNMENTS_F paf

778:
779: CURSOR csr_check_county is
780: select 1
781: from HR_LOCATIONS hrl,
782: PER_ASSIGNMENTS_F paf
783: where paf.assignment_id = p_assignment_id
784: and hrl.location_id = paf.location_id
785: and exists (select null
786: from PAY_US_COUNTIES puc,

Line 801: PER_ASSIGNMENTS_F paf

797: CURSOR csr_check_ovrd_county is
798: select 1
799: from HR_LOCATIONS hrl,
800: HR_SOFT_CODING_KEYFleX hscf,
801: PER_ASSIGNMENTS_F paf
802: where paf.assignment_id = p_assignment_id
803: and hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
804: and hrl.location_id = hscf.segment18
805: and exists (select null

Line 823: PER_ASSIGNMENTS_F paf

819:
820: CURSOR csr_check_city is
821: select 1
822: from HR_LOCATIONS hrl,
823: PER_ASSIGNMENTS_F paf
824: where paf.assignment_id = p_assignment_id
825: and hrl.location_id = paf.location_id
826: and exists (select null
827: from PAY_US_CITY_NAMES puci,

Line 848: PER_ASSIGNMENTS_F paf

844: CURSOR csr_check_ovrd_city is
845: select 1
846: from HR_LOCATIONS hrl,
847: HR_SOFT_CODING_KEYFLEX hscf,
848: PER_ASSIGNMENTS_F paf
849: where paf.assignment_id = p_assignment_id
850: and hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
851: and hrl.location_id = hscf.segment18
852: and exists (select null

Line 1042: PER_ASSIGNMENTS_F paf

1038:
1039: CURSOR csr_check_state is
1040: select 1
1041: from PER_ADDRESSES pa,
1042: PER_ASSIGNMENTS_F paf
1043: where paf.assignment_id = p_assignment_id
1044: and pa.person_id = paf.person_id
1045: and exists (select null
1046: from PAY_US_STATES pus

Line 1056: PER_ASSIGNMENTS_F paf

1052:
1053: CURSOR csr_check_county is
1054: select 1
1055: from PER_ADDRESSES pa,
1056: PER_ASSIGNMENTS_F paf
1057: where paf.assignment_id = p_assignment_id
1058: and pa.person_id = paf.person_id
1059: and exists (select null
1060: from PAY_US_COUNTIES puc,

Line 1077: PER_ASSIGNMENTS_F paf

1073:
1074: CURSOR csr_check_city is
1075: select 1
1076: from PER_ADDRESSES pa,
1077: PER_ASSIGNMENTS_F paf
1078: where paf.assignment_id = p_assignment_id
1079: and pa.person_id = paf.person_id
1080: and exists (select null
1081: from PAY_US_CITY_NAMES puci,

Line 1260: from per_assignments_f paf

1256: /* 11.5.10 changes performance modification. original code
1257: commented out below. */
1258:
1259: select 1
1260: from per_assignments_f paf
1261: ,pay_payroll_actions ppa
1262: ,pay_assignment_actions paa
1263: ,pay_run_results prr
1264: where substr(prr.jurisdiction_code,1,2) = p_state_code

Line 1289: from per_assignments_f paf

1285: CURSOR csr_check_county_purge is
1286: /* 11.5.10 changes performance modification. original code
1287: commented out below. */
1288: select 1
1289: from per_assignments_f paf
1290: ,pay_payroll_actions ppa
1291: ,pay_assignment_actions paa
1292: ,pay_run_results prr
1293: where substr(prr.jurisdiction_code,1,6) = p_state_code || '-'||

Line 1323: from per_assignments_f paf

1319:
1320: /* 11.5.10 changes performance modification. original code
1321: commented out below. */
1322: select 1
1323: from per_assignments_f paf
1324: ,pay_payroll_actions ppa
1325: ,pay_assignment_actions paa
1326: ,pay_run_results prr
1327: where prr.jurisdiction_code = p_state_code || '-'||

Line 1553: from per_assignments_f

1549: cursor csr_get_curr_loc is
1550: select location_id,
1551: effective_start_date,
1552: effective_end_date
1553: from per_assignments_f
1554: where assignment_id = p_assignment_id
1555: and business_group_id + 0 = p_business_group_id
1556: and p_effective_start_date between effective_start_date
1557: and effective_end_date;

Line 1561: from per_assignments_f

1557: and effective_end_date;
1558:
1559: cursor csr_get_future_locations (p_validation_date date)is
1560: select location_id
1561: from per_assignments_f
1562: where assignment_id = p_assignment_id
1563: and business_group_id + 0 = p_business_group_id
1564: and effective_start_date > p_validation_date;
1565:

Line 1633: PER_ASSIGNMENTS_F paf

1629: from PAY_US_CITY_NAMES puci,
1630: PAY_US_COUNTIES puc,
1631: PAY_US_STATES pus,
1632: PER_ADDRESSES pa,
1633: PER_ASSIGNMENTS_F paf
1634: where paf.assignment_id = p_assignment_id
1635: and p_session_date between paf.effective_start_date and
1636: paf.effective_end_date
1637: and pa.person_id = paf.person_id

Line 1710: PER_ASSIGNMENTS_F paf

1706: PAY_US_COUNTIES puc,
1707: PAY_US_STATES pus,
1708: HR_LOCATIONS hrl,
1709: HR_SOFT_CODING_KEYFLEX hscf,
1710: PER_ASSIGNMENTS_F paf
1711: where paf.assignment_id = p_assignment_id
1712: and p_session_date between paf.effective_start_date and
1713: paf.effective_end_date
1714: and hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 2055: PER_ASSIGNMENTS_F paf

2051: /* Override Assignment Data */
2052: cursor csr_get_asgn_locations is
2053: select paf.location_id, hsc.segment18
2054: from HR_SOFT_CODING_KEYFLEX hsc,
2055: PER_ASSIGNMENTS_F paf
2056: where paf.assignment_id = p_assignment_id
2057: and p_session_date between paf.effective_start_date and
2058: paf.effective_end_date
2059: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;

Line 2282: PER_ASSIGNMENTS_F paf

2278: from PAY_US_CITY_NAMES puci,
2279: PAY_US_COUNTIES puc,
2280: PAY_US_STATES pus,
2281: PER_ADDRESSES pa,
2282: PER_ASSIGNMENTS_F paf
2283: where paf.assignment_id = p_assignment_id
2284: and p_session_date between paf.effective_start_date and
2285: paf.effective_end_date
2286: and pa.person_id = paf.person_id