APPS.HR_CA_FF_UDFS dependencies on PAY_USER_COLUMNS

Line 316: FROM pay_user_columns

312: v_ws_id := fnd_number.canonical_to_number(p_wsched);
313:
314: SELECT user_column_name
315: INTO v_ws_name
316: FROM pay_user_columns
317: WHERE user_column_id = v_ws_id
318: AND NVL(legislation_code,'CA') = 'CA';
319:
320: hr_utility.set_location('p_range_start_date='||to_char(p_range_start_date), 19);

Line 906: FROM pay_user_columns

902:
903: --
904: SELECT user_column_name
905: INTO v_work_sched_name
906: FROM pay_user_columns
907: WHERE user_column_id = v_ws_id
908: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
909: AND NVL(legislation_code,'CA') = 'CA';
910: --

Line 2136: FROM pay_user_columns

2132: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2133:
2134: SELECT user_column_name
2135: INTO v_work_sched_name
2136: FROM pay_user_columns
2137: WHERE user_column_id = v_ws_id
2138: AND NVL(business_group_id, p_bg) = p_bg
2139: AND NVL(legislation_code,'CA') = 'CA';
2140:

Line 2325: FROM pay_user_columns

2321: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2322:
2323: SELECT user_column_name
2324: INTO v_work_sched_name
2325: FROM pay_user_columns
2326: WHERE user_column_id = v_ws_id
2327: AND NVL(business_group_id, p_bg) = p_bg
2328: AND NVL(legislation_code,'CA') = 'CA';
2329:

Line 2545: pay_user_columns PUC

2541: BEGIN
2542: select 'Y'
2543: into l_exists
2544: from pay_user_tables PUT,
2545: pay_user_columns PUC
2546: where PUC.USER_COLUMN_NAME = p_ws_name
2547: and PUC.user_table_id = PUT.user_table_id
2548: and PUT.user_table_name = c_ws_tab_name
2549: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id

Line 2562: pay_user_columns PUC

2558: BEGIN
2559: select PUC.USER_COLUMN_NAME
2560: into v_ws_name
2561: from pay_user_tables PUT,
2562: pay_user_columns PUC
2563: where PUC.USER_COLUMN_ID = p_ws_name
2564: and PUT.user_table_name = c_ws_tab_name
2565: and PUC.user_table_id = PUT.user_table_id
2566: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id