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.

[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on PAY_US_COUNTIES

Line 5707: FROM pay_us_counties puc,

5703: RETURN VARCHAR2 IS
5704:
5705: CURSOR c_override_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5706: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5707: FROM pay_us_counties puc,
5708: pay_us_states pus,
5709: pay_us_city_names pucty,
5710: per_addresses pa,
5711: per_assignments_f paf

Line 5732: FROM pay_us_counties puc,

5728:
5729:
5730: CURSOR c_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5731: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5732: FROM pay_us_counties puc,
5733: pay_us_states pus,
5734: pay_us_city_names pucty,
5735: per_addresses pa,
5736: per_assignments_f paf

Line 5795: FROM pay_us_counties puc,

5791: CURSOR c_override_wk_jd (p_assignment_id IN NUMBER,
5792: p_date_earned IN DATE,
5793: p_jurisdiction_code IN VARCHAR2) IS
5794: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5795: FROM pay_us_counties puc,
5796: pay_us_states pus,
5797: pay_us_city_names pucty,
5798: hr_locations hl,
5799: per_assignments_f paf

Line 5818: FROM pay_us_counties puc,

5814: CURSOR c_reg_wk_jd (p_assignment_id IN NUMBER,
5815: p_date_earned IN DATE,
5816: p_jurisdiction_code IN VARCHAR2) IS
5817: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5818: FROM pay_us_counties puc,
5819: pay_us_states pus,
5820: pay_us_city_names pucty,
5821: hr_locations hl,
5822: per_assignments_f paf