DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_USER_TABLES

Line 1963: ,pay_user_tables put

1959: begin
1960: select put.user_table_name
1961: into c_ws_tab_name
1962: from hr_organization_information hoi
1963: ,pay_user_tables put
1964: where hoi.organization_id = p_bg_id
1965: and hoi.org_information_context ='Work Schedule'
1966: and hoi.org_information1 = put.user_table_id ;
1967:

Line 2009: from pay_user_tables PUT,

2005: --
2006: BEGIN
2007: select 'Y'
2008: into l_exists
2009: from pay_user_tables PUT,
2010: pay_user_columns PUC
2011: where PUC.USER_COLUMN_NAME = p_ws_name
2012: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2013: and NVL(PUC.legislation_code,'US') = 'US'

Line 2027: from pay_user_tables PUT,

2023: else
2024: BEGIN
2025: select PUC.USER_COLUMN_NAME
2026: into v_ws_name
2027: from pay_user_tables PUT,
2028: pay_user_columns PUC
2029: where PUC.USER_COLUMN_ID = p_ws_name
2030: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2031: and NVL(PUC.legislation_code,'US') = 'US'