APPS.HR_US_FF_UDFS dependencies on PAY_USER_TABLES

Line 2877: ,pay_user_tables put

2873: begin
2874: select put.user_table_name
2875: into c_ws_tab_name
2876: from hr_organization_information hoi
2877: ,pay_user_tables put
2878: where hoi.organization_id = p_bg_id
2879: and hoi.org_information_context ='Work Schedule'
2880: and hoi.org_information1 = put.user_table_id ;
2881:

Line 2928: from pay_user_tables PUT,

2924: --
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'

Line 2946: from pay_user_tables PUT,

2942: else
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'