APPS.HR_CA_FF_UDFS dependencies on PAY_USER_COLUMNS

Line 310: FROM pay_user_columns

306: v_ws_id := fnd_number.canonical_to_number(p_wsched);
307:
308: SELECT user_column_name
309: INTO v_ws_name
310: FROM pay_user_columns
311: WHERE user_column_id = v_ws_id
312: AND NVL(legislation_code,'CA') = 'CA';
313:
314: hr_utility.set_location('p_range_start_date='||to_char(p_range_start_date), 19);

Line 900: FROM pay_user_columns

896:
897: --
898: SELECT user_column_name
899: INTO v_work_sched_name
900: FROM pay_user_columns
901: WHERE user_column_id = v_ws_id
902: AND NVL(business_group_id, p_bus_grp_id) = p_bus_grp_id
903: AND NVL(legislation_code,'CA') = 'CA';
904: --

Line 2099: FROM pay_user_columns

2095: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2096:
2097: SELECT user_column_name
2098: INTO v_work_sched_name
2099: FROM pay_user_columns
2100: WHERE user_column_id = v_ws_id
2101: AND NVL(business_group_id, p_bg) = p_bg
2102: AND NVL(legislation_code,'CA') = 'CA';
2103:

Line 2288: FROM pay_user_columns

2284: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2285:
2286: SELECT user_column_name
2287: INTO v_work_sched_name
2288: FROM pay_user_columns
2289: WHERE user_column_id = v_ws_id
2290: AND NVL(business_group_id, p_bg) = p_bg
2291: AND NVL(legislation_code,'CA') = 'CA';
2292:

Line 2508: pay_user_columns PUC

2504: BEGIN
2505: select 'Y'
2506: into l_exists
2507: from pay_user_tables PUT,
2508: pay_user_columns PUC
2509: where PUC.USER_COLUMN_NAME = p_ws_name
2510: and PUC.user_table_id = PUT.user_table_id
2511: and PUT.user_table_name = c_ws_tab_name
2512: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id

Line 2525: pay_user_columns PUC

2521: BEGIN
2522: select PUC.USER_COLUMN_NAME
2523: into v_ws_name
2524: from pay_user_tables PUT,
2525: pay_user_columns PUC
2526: where PUC.USER_COLUMN_ID = p_ws_name
2527: and PUT.user_table_name = c_ws_tab_name
2528: and PUC.user_table_id = PUT.user_table_id
2529: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id