DBA Data[Home] [Help]

APPS.PAY_CA_RULES dependencies on PAY_USER_COLUMNS

Line 473: pay_user_columns PUC

469: BEGIN
470: select 'Y'
471: into l_exists
472: from pay_user_tables PUT,
473: pay_user_columns PUC
474: where PUC.USER_COLUMN_NAME = p_ws_name
475: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
476: and NVL(PUC.legislation_code,'CA') = 'CA'
477: and PUC.user_table_id = PUT.user_table_id

Line 491: pay_user_columns PUC

487: BEGIN
488: select PUC.USER_COLUMN_NAME
489: into v_ws_name
490: from pay_user_tables PUT,
491: pay_user_columns PUC
492: where PUC.USER_COLUMN_ID = p_ws_name
493: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
494: and NVL(PUC.legislation_code,'CA') = 'CA'
495: and PUC.user_table_id = PUT.user_table_id