DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_USER_COLUMNS

Line 2010: pay_user_columns PUC

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'
2014: and PUC.user_table_id = PUT.user_table_id

Line 2028: pay_user_columns PUC

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'
2032: and PUC.user_table_id = PUT.user_table_id