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 584: FROM pay_user_columns

580: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
581:
582: SELECT user_column_name
583: INTO v_ws_name
584: FROM pay_user_columns
585: WHERE user_column_id = v_ws_id
586: AND NVL(business_group_id, p_bg_id) = p_bg_id
587: AND NVL(legislation_code,'US') = 'US';
588:

Line 1272: FROM pay_user_columns

1268: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1269: --
1270: SELECT user_column_name
1271: INTO v_work_sched_name
1272: FROM pay_user_columns
1273: WHERE user_column_id = v_ws_id
1274: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
1275: AND NVL(legislation_code,'US') = 'US';
1276:

Line 2456: FROM pay_user_columns

2452:
2453:
2454: SELECT user_column_name
2455: INTO v_work_sched_name
2456: FROM pay_user_columns
2457: WHERE user_column_id = v_ws_id
2458: AND NVL(business_group_id, p_bg) = p_bg
2459: AND NVL(legislation_code,'US') = 'US';
2460:

Line 2630: FROM pay_user_columns

2626: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2627:
2628: SELECT user_column_name
2629: INTO v_work_sched_name
2630: FROM pay_user_columns
2631: WHERE user_column_id = v_ws_id
2632: AND NVL(business_group_id, p_bg) = p_bg
2633: AND NVL(legislation_code,'US') = 'US';
2634:

Line 2929: pay_user_columns PUC

2925: BEGIN
2926: select 'Y'
2927: into l_exists
2928: from pay_user_tables PUT,
2929: pay_user_columns PUC
2930: where PUC.USER_COLUMN_NAME = p_ws_name
2931: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2932: and NVL(PUC.legislation_code,'US') = 'US'
2933: and PUC.user_table_id = PUT.user_table_id

Line 2947: pay_user_columns PUC

2943: BEGIN
2944: select PUC.USER_COLUMN_NAME
2945: into v_ws_name
2946: from pay_user_tables PUT,
2947: pay_user_columns PUC
2948: where PUC.USER_COLUMN_ID = p_ws_name
2949: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2950: and NVL(PUC.legislation_code,'US') = 'US'
2951: and PUC.user_table_id = PUT.user_table_id