APPS.HR_US_FF_UDF1 dependencies on HR_US_FF_UDFS

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

362: RETURN NUMBER IS
363:
364: CURSOR csr_l_home_juris (p_assignment_action_id IN NUMBER) IS
365:
366: SELECT hr_us_ff_udfs.addr_val(NVL(add_information17, region_2),
367: NVL(add_information19, region_1),
368: NVL(add_information18, town_or_city),
369: NVL(add_information20, postal_code)
370: )

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

448:
449:
450: /* commented for bug 7238809 .As fetching home jurisdiction using
451: fnd sessions does not pick the correct value .
452: SELECT hr_us_ff_udfs.addr_val(NVL(add_information17, region_2),
453: NVL(add_information19, region_1),
454: NVL(add_information18, town_or_city),
455: NVL(add_information20, postal_code)
456: )

Line 1556: l_res_jurisdiction_code := hr_us_ff_udfs.addr_val(l_res_state

1552: and l_date_earned BETWEEN nvl(ADDR.date_from, l_date_earned)
1553: AND nvl(ADDR.date_to, l_date_earned);
1554:
1555: hr_utility.trace('2nd query returned res address details');
1556: l_res_jurisdiction_code := hr_us_ff_udfs.addr_val(l_res_state
1557: , l_res_county
1558: , l_res_city
1559: , l_res_zip);
1560:

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

1735: AND nvl(HRSCKF.segment18,
1736: ASSIGN.location_id) = HRLOC.location_id;
1737: l_jd_found := 'N';
1738: hr_utility.trace('Primary work location query');
1739: l_jurisdiction_code := hr_us_ff_udfs.addr_val(l_state,
1740: l_county,
1741: l_city,
1742: l_zip_code);
1743: hr_utility.trace('Primary work loc JD CODE = ' ||

Line 3038: hr_us_ff_udfs.work_schedule_total_hours(p_business_group_id,

3034:
3035: /* need to use l_ws_start_date and l_ws_end_date for work scheduled hours calculation */
3036:
3037: l_scheduled_work_hours :=
3038: hr_us_ff_udfs.work_schedule_total_hours(p_business_group_id,
3039: l_ws_name,
3040: l_ws_start_date,
3041: l_ws_end_date);
3042:

Line 3047: hr_us_ff_udfs.work_schedule_total_hours(p_business_group_id,

3043: IF l_ws_start_date = l_ws_end_date AND
3044: NVL(l_scheduled_work_hours,0) <= 0 THEN
3045:
3046: l_scheduled_work_hours :=
3047: hr_us_ff_udfs.work_schedule_total_hours(p_business_group_id,
3048: l_ws_name,
3049: l_ws_start_date,
3050: l_ws_end_date);
3051: IF l_scheduled_work_hours = 0 THEN

Line 3088: l_res_jurisdiction_code := hr_us_ff_udfs.addr_val(l_res_state

3084:
3085: CLOSE csr_resident_jd;
3086:
3087: hr_utility.trace('EMJT : get_it_work_jurisdictions Resident Address Fetched');
3088: l_res_jurisdiction_code := hr_us_ff_udfs.addr_val(l_res_state
3089: , l_res_county
3090: , l_res_city
3091: , l_res_zip);
3092:

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

3116: hr_utility.trace('EMJT : Primary Work Location address componets NOT Found');
3117: END IF;
3118: CLOSE csr_work_jd;
3119: hr_utility.trace('EMJT : Determine Jurisdiction Code for Primary Work Location');
3120: l_work_jurisdiction_code := hr_us_ff_udfs.addr_val(l_state,
3121: l_county,
3122: l_city,
3123: l_zip_code);
3124: