DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on PAY_USER_COLUMNS

Line 349: pay_user_columns puc

345: puc.user_column_name
346: from
347: per_assignments_f paf,
348: hr_soft_coding_keyflex hsck,
349: pay_user_columns puc
350: where
351: paf.assignment_id = p_asg_id and
352: paf.business_group_id = p_business_group_id and
353: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and

Line 360: l_user_column_name pay_user_columns.user_column_name%TYPE;

356: paf.effective_end_date and
357: hsck.segment4 = puc.user_column_id;
358:
359: l_working_date date;
360: l_user_column_name pay_user_columns.user_column_name%TYPE;
361: c_ws_tab_name VARCHAR2(80) := 'COMPANY WORK SCHEDULES';
362: l_hour number := 0;
363: v_curr_day varchar2(5);
364: