APPS.HR_US_FF_UDFS dependencies on PAY_USER_COLUMNS

Line 230: pay_user_columns

226: work_schedule_total_hours to
227: check for business_group_id and
228: user_table_id while obtaining
229: user_column_name from
230: pay_user_columns
231: 01-JUL-2000 vmehta 115.19 Added a check of the last 3 characters
232: in the city name. This is to fix a
233: problem where Air Force Bases (in the
234: City_name would error during processing

Line 575: FROM pay_user_columns

571: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
572:
573: SELECT user_column_name
574: INTO v_ws_name
575: FROM pay_user_columns
576: WHERE user_column_id = v_ws_id
577: AND NVL(business_group_id, p_bg_id) = p_bg_id
578: AND NVL(legislation_code,'US') = 'US';
579:

Line 1263: FROM pay_user_columns

1259: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1260: --
1261: SELECT user_column_name
1262: INTO v_work_sched_name
1263: FROM pay_user_columns
1264: WHERE user_column_id = v_ws_id
1265: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
1266: AND NVL(legislation_code,'US') = 'US';
1267:

Line 2447: FROM pay_user_columns

2443:
2444:
2445: SELECT user_column_name
2446: INTO v_work_sched_name
2447: FROM pay_user_columns
2448: WHERE user_column_id = v_ws_id
2449: AND NVL(business_group_id, p_bg) = p_bg
2450: AND NVL(legislation_code,'US') = 'US';
2451:

Line 2621: FROM pay_user_columns

2617: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2618:
2619: SELECT user_column_name
2620: INTO v_work_sched_name
2621: FROM pay_user_columns
2622: WHERE user_column_id = v_ws_id
2623: AND NVL(business_group_id, p_bg) = p_bg
2624: AND NVL(legislation_code,'US') = 'US';
2625:

Line 2920: pay_user_columns PUC

2916: BEGIN
2917: select 'Y'
2918: into l_exists
2919: from pay_user_tables PUT,
2920: pay_user_columns PUC
2921: where PUC.USER_COLUMN_NAME = p_ws_name
2922: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2923: and NVL(PUC.legislation_code,'US') = 'US'
2924: and PUC.user_table_id = PUT.user_table_id

Line 2938: pay_user_columns PUC

2934: BEGIN
2935: select PUC.USER_COLUMN_NAME
2936: into v_ws_name
2937: from pay_user_tables PUT,
2938: pay_user_columns PUC
2939: where PUC.USER_COLUMN_ID = p_ws_name
2940: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2941: and NVL(PUC.legislation_code,'US') = 'US'
2942: and PUC.user_table_id = PUT.user_table_id