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 347: INDEX (paf PER_ASSIGNMENTS_F_PK) */

343: 'SELECT /*+ ORDERED
344: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
345: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
346: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
347: INDEX (paf PER_ASSIGNMENTS_F_PK) */
348: DISTINCT paf.person_id
349: FROM pay_payroll_actions ppa,
350: pay_payroll_actions pa1,
351: pay_assignment_actions act,

Line 352: per_assignments_f paf

348: DISTINCT paf.person_id
349: FROM pay_payroll_actions ppa,
350: pay_payroll_actions pa1,
351: pay_assignment_actions act,
352: per_assignments_f paf
353: WHERE ppa.payroll_action_id = :payroll_action_id
354: AND pa1.effective_date >= fnd_date.canonical_to_date('''|| lv_cur_date ||''')
355: AND pa1.effective_date <= ppa.effective_date
356: AND pa1.payroll_action_id = act.payroll_action_id

Line 832: FROM per_assignments_f paf1

828: AND paa1.payroll_action_id = ppa1.payroll_action_id
829: AND paa1.assignment_id = paf.assignment_id
830: AND paf.effective_start_date =
831: (SELECT MAX(paf1.effective_start_date)
832: FROM per_assignments_f paf1
833: WHERE paf1.assignment_id = paf.assignment_id
834: AND paf1.effective_start_date <= ppa1.effective_date
835: AND paf1.effective_end_date >=
836: DECODE(payusunb_pkg.fnc_get_parameter(''B_Dim'',

Line 1523: ORGANIZATION_ID := organization_id (from per_assignments_f)

1519: header record and the other is detail record.
1520: column mapping specs for header record:
1521: SESSION_ID := payroll_action_id (PYUGEN Payroll Action)
1522: TAX_UNIT_ID := tax_unit_id (from pay_assignment_actions)
1523: ORGANIZATION_ID := organization_id (from per_assignments_f)
1524: LOCATION_ID := location_id (from per_assignments_f)
1525: BUSINESS_GROUP_ID := chunk number from PYUGEN process
1526: VALUE1 := person_id
1527: GRE_NAME := assignment_number (from per_assignments_f)

Line 1524: LOCATION_ID := location_id (from per_assignments_f)

1520: column mapping specs for header record:
1521: SESSION_ID := payroll_action_id (PYUGEN Payroll Action)
1522: TAX_UNIT_ID := tax_unit_id (from pay_assignment_actions)
1523: ORGANIZATION_ID := organization_id (from per_assignments_f)
1524: LOCATION_ID := location_id (from per_assignments_f)
1525: BUSINESS_GROUP_ID := chunk number from PYUGEN process
1526: VALUE1 := person_id
1527: GRE_NAME := assignment_number (from per_assignments_f)
1528: STATE_CODE := H indicating this record is header record

Line 1527: GRE_NAME := assignment_number (from per_assignments_f)

1523: ORGANIZATION_ID := organization_id (from per_assignments_f)
1524: LOCATION_ID := location_id (from per_assignments_f)
1525: BUSINESS_GROUP_ID := chunk number from PYUGEN process
1526: VALUE1 := person_id
1527: GRE_NAME := assignment_number (from per_assignments_f)
1528: STATE_CODE := H indicating this record is header record
1529: VALUE6 := assignment_action_id
1530: Each header record may have multiple detail records and the key
1531: used to link header to detail records is assignment_action_id

Line 1859: per_assignments_f paf,

1855: prb.jurisdiction_code||'-000-0000' jurisdiction_code,
1856: pus.state_code state_code,
1857: pus.state_abbrev
1858: FROM pay_run_balances prb,
1859: per_assignments_f paf,
1860: pay_us_states pus
1861: WHERE paf.person_id = IN_person_id
1862: AND prb.effective_date BETWEEN IN_start_date and IN_as_of_date
1863: AND prb.effective_date BETWEEN paf.effective_start_date

Line 1880: per_assignments_f paf,

1876: SELECT DISTINCT
1877: prb.jurisdiction_code||'-0000' jurisdiction_code,
1878: puc.county_name||','||pus.state_abbrev jurisdiction_name
1879: FROM pay_run_balances prb,
1880: per_assignments_f paf,
1881: pay_us_states pus,
1882: pay_us_counties puc
1883: WHERE paf.person_id = IN_person_id
1884: AND paf.effective_start_date <= IN_as_of_date

Line 1906: per_assignments_f paf,

1902: SELECT DISTINCT
1903: prb.jurisdiction_code,
1904: pun.city_name||','||pus.state_abbrev jurisdiction_name
1905: FROM pay_run_balances prb,
1906: per_assignments_f paf,
1907: pay_us_states pus,
1908: pay_us_city_names pun
1909: WHERE paf.person_id = IN_person_id
1910: AND paf.effective_start_date <= IN_as_of_date

Line 1938: per_assignments_f paf,

1934: prb.jurisdiction_code,
1935: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1936: psd.state_code||'-'||psd.county_code||'-'||psd.city_code reg_jurisdiction_cd
1937: FROM pay_run_balances prb,
1938: per_assignments_f paf,
1939: pay_us_states pus,
1940: pay_us_city_school_dsts psd
1941: WHERE paf.person_id = IN_person_id
1942: AND paf.effective_start_date <= IN_as_of_date

Line 1960: FROM per_assignments_f paf,

1956: SELECT /*+ ORDERED */DISTINCT
1957: prb.jurisdiction_code,
1958: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1959: psd.state_code||'-'||psd.county_code||'-0000' reg_jurisdiction_cd
1960: FROM per_assignments_f paf,
1961: pay_run_balances prb,
1962: pay_us_states pus,
1963: pay_us_county_school_dsts psd
1964: WHERE paf.person_id = IN_person_id

Line 1993: per_assignments_f paf,

1989: pes.jurisdiction_code,
1990: pes.state_code,
1991: pus.state_abbrev
1992: FROM pay_us_emp_state_tax_rules_f pes,
1993: per_assignments_f paf,
1994: pay_us_states pus
1995: WHERE pes.assignment_id = paf.assignment_id
1996: AND pes.state_code = pus.state_code
1997: AND paf.effective_start_date BETWEEN pes.effective_start_date

Line 2038: per_assignments_f paf,

2034: IN_as_of_date IN DATE) IS
2035: SELECT DISTINCT pes.jurisdiction_code,
2036: puc.county_name||','||pus.state_abbrev jurisdiction_name
2037: FROM pay_us_emp_county_tax_rules_f pes,
2038: per_assignments_f paf,
2039: pay_us_states pus,
2040: pay_us_counties puc
2041: WHERE pes.assignment_id = paf.assignment_id
2042: AND pes.state_code = pus.state_code

Line 2083: per_assignments_f paf,

2079: SELECT DISTINCT
2080: pes.jurisdiction_code,
2081: pun.city_name||','||pus.state_abbrev jurisdiction_name
2082: FROM pay_us_emp_city_tax_rules_f pes,
2083: per_assignments_f paf,
2084: pay_us_states pus,
2085: pay_us_city_names pun
2086: WHERE pes.assignment_id = paf.assignment_id
2087: AND pes.state_code = pus.state_code

Line 2132: per_assignments_f paf,

2128: pes.state_code||'-'||pes.school_district_code jurisdiction_code,
2129: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
2130: pes.jurisdiction_code reg_jurisdiction_cd
2131: FROM pay_us_emp_city_tax_rules_f pes,
2132: per_assignments_f paf,
2133: pay_us_states pus,
2134: pay_us_city_school_dsts psd
2135: WHERE pes.assignment_id = paf.assignment_id
2136: AND pes.school_district_code IS NOT NULL

Line 2175: per_assignments_f paf,

2171: pes.state_code||'-'||pes.school_district_code jurisdiction_code,
2172: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
2173: pes.jurisdiction_code reg_jurisdiction_cd
2174: FROM pay_us_emp_county_tax_rules_f pes,
2175: per_assignments_f paf,
2176: pay_us_states pus,
2177: pay_us_county_school_dsts psd
2178: WHERE pes.assignment_id = paf.assignment_id
2179: AND pes.school_district_code IS NOT NULL

Line 4419: from per_assignments_f

4415: l_cursor_fetch_date := L_as_of_date;
4416:
4417: select count(0)
4418: into l_asg_exists
4419: from per_assignments_f
4420: where assignment_id = IN_prc_assignment_id
4421: and L_as_of_date between effective_start_date and effective_end_date;
4422: --
4423: -- if assignment doesn't exist ...

Line 4433: from per_assignments_f

4429: -- get the termination date ...
4430: --
4431: select max(effective_end_date)
4432: into l_cursor_fetch_date
4433: from per_assignments_f
4434: where assignment_id = IN_prc_assignment_id;
4435: ELSE
4436: l_cursor_fetch_date := L_as_of_date;
4437: END IF;