DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_USER_COLUMNS

Line 3107: FROM pay_user_columns

3103:
3104:
3105: SELECT user_column_name
3106: INTO v_work_sched_name
3107: FROM pay_user_columns
3108: WHERE user_column_id = v_ws_id
3109: AND NVL(business_group_id, p_bg) = p_bg
3110: AND NVL(legislation_code,'US') = 'US';
3111:

Line 3281: FROM pay_user_columns

3277: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
3278:
3279: SELECT user_column_name
3280: INTO v_work_sched_name
3281: FROM pay_user_columns
3282: WHERE user_column_id = v_ws_id
3283: AND NVL(business_group_id, p_bg) = p_bg
3284: AND NVL(legislation_code,'US') = 'US';
3285:

Line 3947: pay_user_columns puc

3943: select puci.value
3944: from pay_user_column_instances_f puci,
3945: pay_user_tables put,
3946: pay_user_rows_f pur,
3947: pay_user_columns puc
3948: where puci.user_column_id = puc.user_column_id
3949: and puci.user_row_id = pur.user_row_id
3950: and put.user_table_id = puc.user_table_id
3951: and put.user_table_id = pur.user_table_id