APPS.HR_US_FF_UDFS dependencies on PAY_USER_TABLES

Line 2868: ,pay_user_tables put

2864: begin
2865: select put.user_table_name
2866: into c_ws_tab_name
2867: from hr_organization_information hoi
2868: ,pay_user_tables put
2869: where hoi.organization_id = p_bg_id
2870: and hoi.org_information_context ='Work Schedule'
2871: and hoi.org_information1 = put.user_table_id ;
2872:

Line 2919: from pay_user_tables PUT,

2915: --
2916: BEGIN
2917: select 'Y'
2918: into l_exists
2919: from pay_user_tables PUT,
2920: pay_user_columns PUC
2921: where PUC.USER_COLUMN_NAME = p_ws_name
2922: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2923: and NVL(PUC.legislation_code,'US') = 'US'

Line 2937: from pay_user_tables PUT,

2933: else
2934: BEGIN
2935: select PUC.USER_COLUMN_NAME
2936: into v_ws_name
2937: from pay_user_tables PUT,
2938: pay_user_columns PUC
2939: where PUC.USER_COLUMN_ID = p_ws_name
2940: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2941: and NVL(PUC.legislation_code,'US') = 'US'