DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_USER_COLUMNS

Line 2068: pay_user_columns PUC

2064: BEGIN
2065: select 'Y'
2066: into l_exists
2067: from pay_user_tables PUT,
2068: pay_user_columns PUC
2069: where PUC.USER_COLUMN_NAME = p_ws_name
2070: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2071: and NVL(PUC.legislation_code,'US') = 'US'
2072: and PUC.user_table_id = PUT.user_table_id

Line 2086: pay_user_columns PUC

2082: BEGIN
2083: select PUC.USER_COLUMN_NAME
2084: into v_ws_name
2085: from pay_user_tables PUT,
2086: pay_user_columns PUC
2087: where PUC.USER_COLUMN_ID = p_ws_name
2088: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
2089: and NVL(PUC.legislation_code,'US') = 'US'
2090: and PUC.user_table_id = PUT.user_table_id