DBA Data[Home] [Help]

APPS.PAY_CA_RULES dependencies on PAY_USER_COLUMNS

Line 1160: pay_user_columns PUC

1156: BEGIN
1157: select 'Y'
1158: into l_exists
1159: from pay_user_tables PUT,
1160: pay_user_columns PUC
1161: where PUC.USER_COLUMN_NAME = p_ws_name
1162: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
1163: and NVL(PUC.legislation_code,'CA') = 'CA'
1164: and PUC.user_table_id = PUT.user_table_id

Line 1178: pay_user_columns PUC

1174: BEGIN
1175: select PUC.USER_COLUMN_NAME
1176: into v_ws_name
1177: from pay_user_tables PUT,
1178: pay_user_columns PUC
1179: where PUC.USER_COLUMN_ID = p_ws_name
1180: and NVL(PUC.business_group_id, p_bg_id) = p_bg_id
1181: and NVL(PUC.legislation_code,'CA') = 'CA'
1182: and PUC.user_table_id = PUT.user_table_id