APPS.PAY_CORE_FF_UDFS dependencies on PAY_USER_COLUMNS

Line 178: pay_user_columns PUC

174: ,p_bg_id NUMBER) IS
175: select PUC.user_column_id
176: ,PUC.user_column_name
177: from pay_user_tables PUT,
178: pay_user_columns PUC
179: where PUC.USER_COLUMN_ID = p_user_col_id
180: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
181: and NVL(PUC.legislation_code,'US') = 'US'
182: and PUC.user_table_id = PUT.user_table_id

Line 1259: FROM pay_user_columns

1255: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1256:
1257: SELECT user_column_name
1258: INTO v_ws_name
1259: FROM pay_user_columns
1260: WHERE user_column_id = v_ws_id
1261: AND NVL(business_group_id, p_bg_id) = p_bg_id
1262: AND NVL(legislation_code,'US') = 'US';
1263:

Line 2014: FROM pay_user_columns

2010: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
2011: --
2012: SELECT user_column_name
2013: INTO v_work_sched_name
2014: FROM pay_user_columns
2015: WHERE user_column_id = v_ws_id
2016: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
2017: AND NVL(legislation_code,'US') = 'US';
2018: