APPS.HR_US_FF_UDF1 dependencies on HR_US_FF_UDFS

Line 325: SELECT hr_us_ff_udfs.addr_val(NVL(add_information17, region_2),

321: RETURN NUMBER IS
322:
323: CURSOR csr_l_home_juris (p_assignment_action_id IN NUMBER) IS
324:
325: SELECT hr_us_ff_udfs.addr_val(NVL(add_information17, region_2),
326: NVL(add_information19, region_1),
327: NVL(add_information18, town_or_city),
328: NVL(add_information20, postal_code)
329: )

Line 411: SELECT hr_us_ff_udfs.addr_val(NVL(add_information17, region_2),

407:
408:
409: /* commented for bug 7238809 .As fetching home jurisdiction using
410: fnd sessions does not pick the correct value .
411: SELECT hr_us_ff_udfs.addr_val(NVL(add_information17, region_2),
412: NVL(add_information19, region_1),
413: NVL(add_information18, town_or_city),
414: NVL(add_information20, postal_code)
415: )

Line 1515: l_res_jurisdiction_code := hr_us_ff_udfs.addr_val(l_res_state

1511: and l_date_earned BETWEEN nvl(ADDR.date_from, l_date_earned)
1512: AND nvl(ADDR.date_to, l_date_earned);
1513:
1514: hr_utility.trace('2nd query returned res address details');
1515: l_res_jurisdiction_code := hr_us_ff_udfs.addr_val(l_res_state
1516: , l_res_county
1517: , l_res_city
1518: , l_res_zip);
1519:

Line 1698: l_jurisdiction_code := hr_us_ff_udfs.addr_val(l_state,

1694: AND nvl(HRSCKF.segment18,
1695: ASSIGN.location_id) = HRLOC.location_id;
1696: l_jd_found := 'N';
1697: hr_utility.trace('Primary work location query');
1698: l_jurisdiction_code := hr_us_ff_udfs.addr_val(l_state,
1699: l_county,
1700: l_city,
1701: l_zip_code);
1702: hr_utility.trace('Primary work loc JD CODE = ' ||

Line 2939: hr_us_ff_udfs.work_schedule_total_hours(p_business_group_id,

2935:
2936: /* need to use l_ws_start_date and l_ws_end_date for work scheduled hours calculation */
2937:
2938: l_scheduled_work_hours :=
2939: hr_us_ff_udfs.work_schedule_total_hours(p_business_group_id,
2940: l_ws_name,
2941: l_ws_start_date,
2942: l_ws_end_date);
2943:

Line 2948: hr_us_ff_udfs.work_schedule_total_hours(p_business_group_id,

2944: IF l_ws_start_date = l_ws_end_date AND
2945: NVL(l_scheduled_work_hours,0) <= 0 THEN
2946:
2947: l_scheduled_work_hours :=
2948: hr_us_ff_udfs.work_schedule_total_hours(p_business_group_id,
2949: l_ws_name,
2950: l_ws_start_date,
2951: l_ws_end_date);
2952: IF l_scheduled_work_hours = 0 THEN

Line 2989: l_res_jurisdiction_code := hr_us_ff_udfs.addr_val(l_res_state

2985:
2986: CLOSE csr_resident_jd;
2987:
2988: hr_utility.trace('EMJT : get_it_work_jurisdictions Resident Address Fetched');
2989: l_res_jurisdiction_code := hr_us_ff_udfs.addr_val(l_res_state
2990: , l_res_county
2991: , l_res_city
2992: , l_res_zip);
2993:

Line 3021: l_work_jurisdiction_code := hr_us_ff_udfs.addr_val(l_state,

3017: hr_utility.trace('EMJT : Primary Work Location address componets NOT Found');
3018: END IF;
3019: CLOSE csr_work_jd;
3020: hr_utility.trace('EMJT : Determine Jurisdiction Code for Primary Work Location');
3021: l_work_jurisdiction_code := hr_us_ff_udfs.addr_val(l_state,
3022: l_county,
3023: l_city,
3024: l_zip_code);
3025: