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

Line 270: INDEX (paf PER_ASSIGNMENTS_F_PK) */

266: 'SELECT /*+ ORDERED
267: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
268: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
269: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
270: INDEX (paf PER_ASSIGNMENTS_F_PK) */
271: DISTINCT paf.person_id
272: FROM pay_payroll_actions ppa,
273: pay_payroll_actions pa1,
274: pay_assignment_actions act,

Line 275: per_assignments_f paf

271: DISTINCT paf.person_id
272: FROM pay_payroll_actions ppa,
273: pay_payroll_actions pa1,
274: pay_assignment_actions act,
275: per_assignments_f paf
276: WHERE ppa.payroll_action_id = :payroll_action_id
277: AND pa1.effective_date >= fnd_date.canonical_to_date('''|| lv_cur_date ||''')
278: AND pa1.effective_date <= ppa.effective_date
279: AND pa1.payroll_action_id = act.payroll_action_id

Line 601: FROM per_assignments_f paf1

597: AND paa1.payroll_action_id = ppa1.payroll_action_id
598: AND paa1.assignment_id = paf.assignment_id
599: AND paf.effective_start_date =
600: (SELECT MAX(paf1.effective_start_date)
601: FROM per_assignments_f paf1
602: WHERE paf1.assignment_id = paf.assignment_id
603: AND paf1.effective_start_date <= ppa1.effective_date
604: AND paf1.effective_end_date >=
605: DECODE(payusunb_pkg.fnc_get_parameter(''B_Dim'',

Line 1038: ORGANIZATION_ID := organization_id (from per_assignments_f)

1034: header record and the other is detail record.
1035: column mapping specs for header record:
1036: SESSION_ID := payroll_action_id (PYUGEN Payroll Action)
1037: TAX_UNIT_ID := tax_unit_id (from pay_assignment_actions)
1038: ORGANIZATION_ID := organization_id (from per_assignments_f)
1039: LOCATION_ID := location_id (from per_assignments_f)
1040: BUSINESS_GROUP_ID := chunk number from PYUGEN process
1041: VALUE1 := person_id
1042: GRE_NAME := assignment_number (from per_assignments_f)

Line 1039: LOCATION_ID := location_id (from per_assignments_f)

1035: column mapping specs for header record:
1036: SESSION_ID := payroll_action_id (PYUGEN Payroll Action)
1037: TAX_UNIT_ID := tax_unit_id (from pay_assignment_actions)
1038: ORGANIZATION_ID := organization_id (from per_assignments_f)
1039: LOCATION_ID := location_id (from per_assignments_f)
1040: BUSINESS_GROUP_ID := chunk number from PYUGEN process
1041: VALUE1 := person_id
1042: GRE_NAME := assignment_number (from per_assignments_f)
1043: STATE_CODE := H indicating this record is header record

Line 1042: GRE_NAME := assignment_number (from per_assignments_f)

1038: ORGANIZATION_ID := organization_id (from per_assignments_f)
1039: LOCATION_ID := location_id (from per_assignments_f)
1040: BUSINESS_GROUP_ID := chunk number from PYUGEN process
1041: VALUE1 := person_id
1042: GRE_NAME := assignment_number (from per_assignments_f)
1043: STATE_CODE := H indicating this record is header record
1044: VALUE6 := assignment_action_id
1045: Each header record may have multiple detail records and the key
1046: used to link header to detail records is assignment_action_id

Line 1374: per_assignments_f paf,

1370: prb.jurisdiction_code||'-000-0000' jurisdiction_code,
1371: pus.state_code state_code,
1372: pus.state_abbrev
1373: FROM pay_run_balances prb,
1374: per_assignments_f paf,
1375: pay_us_states pus
1376: WHERE paf.person_id = IN_person_id
1377: AND prb.effective_date BETWEEN IN_start_date and IN_as_of_date
1378: AND prb.effective_date BETWEEN paf.effective_start_date

Line 1395: per_assignments_f paf,

1391: SELECT DISTINCT
1392: prb.jurisdiction_code||'-0000' jurisdiction_code,
1393: puc.county_name||','||pus.state_abbrev jurisdiction_name
1394: FROM pay_run_balances prb,
1395: per_assignments_f paf,
1396: pay_us_states pus,
1397: pay_us_counties puc
1398: WHERE paf.person_id = IN_person_id
1399: AND paf.effective_start_date <= IN_as_of_date

Line 1421: per_assignments_f paf,

1417: SELECT DISTINCT
1418: prb.jurisdiction_code,
1419: pun.city_name||','||pus.state_abbrev jurisdiction_name
1420: FROM pay_run_balances prb,
1421: per_assignments_f paf,
1422: pay_us_states pus,
1423: pay_us_city_names pun
1424: WHERE paf.person_id = IN_person_id
1425: AND paf.effective_start_date <= IN_as_of_date

Line 1453: per_assignments_f paf,

1449: prb.jurisdiction_code,
1450: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1451: psd.state_code||'-'||psd.county_code||'-'||psd.city_code reg_jurisdiction_cd
1452: FROM pay_run_balances prb,
1453: per_assignments_f paf,
1454: pay_us_states pus,
1455: pay_us_city_school_dsts psd
1456: WHERE paf.person_id = IN_person_id
1457: AND paf.effective_start_date <= IN_as_of_date

Line 1475: FROM per_assignments_f paf,

1471: SELECT /*+ ORDERED */DISTINCT
1472: prb.jurisdiction_code,
1473: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1474: psd.state_code||'-'||psd.county_code||'-0000' reg_jurisdiction_cd
1475: FROM per_assignments_f paf,
1476: pay_run_balances prb,
1477: pay_us_states pus,
1478: pay_us_county_school_dsts psd
1479: WHERE paf.person_id = IN_person_id

Line 1508: per_assignments_f paf,

1504: pes.jurisdiction_code,
1505: pes.state_code,
1506: pus.state_abbrev
1507: FROM pay_us_emp_state_tax_rules_f pes,
1508: per_assignments_f paf,
1509: pay_us_states pus
1510: WHERE pes.assignment_id = paf.assignment_id
1511: AND pes.state_code = pus.state_code
1512: AND paf.effective_start_date BETWEEN pes.effective_start_date

Line 1550: per_assignments_f paf,

1546: IN_as_of_date IN DATE) IS
1547: SELECT DISTINCT pes.jurisdiction_code,
1548: puc.county_name||','||pus.state_abbrev jurisdiction_name
1549: FROM pay_us_emp_county_tax_rules_f pes,
1550: per_assignments_f paf,
1551: pay_us_states pus,
1552: pay_us_counties puc
1553: WHERE pes.assignment_id = paf.assignment_id
1554: AND pes.state_code = pus.state_code

Line 1595: per_assignments_f paf,

1591: SELECT DISTINCT
1592: pes.jurisdiction_code,
1593: pun.city_name||','||pus.state_abbrev jurisdiction_name
1594: FROM pay_us_emp_city_tax_rules_f pes,
1595: per_assignments_f paf,
1596: pay_us_states pus,
1597: pay_us_city_names pun
1598: WHERE pes.assignment_id = paf.assignment_id
1599: AND pes.state_code = pus.state_code

Line 1644: per_assignments_f paf,

1640: pes.state_code||'-'||pes.school_district_code jurisdiction_code,
1641: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1642: pes.jurisdiction_code reg_jurisdiction_cd
1643: FROM pay_us_emp_city_tax_rules_f pes,
1644: per_assignments_f paf,
1645: pay_us_states pus,
1646: pay_us_city_school_dsts psd
1647: WHERE pes.assignment_id = paf.assignment_id
1648: AND pes.school_district_code IS NOT NULL

Line 1687: per_assignments_f paf,

1683: pes.state_code||'-'||pes.school_district_code jurisdiction_code,
1684: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1685: pes.jurisdiction_code reg_jurisdiction_cd
1686: FROM pay_us_emp_county_tax_rules_f pes,
1687: per_assignments_f paf,
1688: pay_us_states pus,
1689: pay_us_county_school_dsts psd
1690: WHERE pes.assignment_id = paf.assignment_id
1691: AND pes.school_district_code IS NOT NULL