APPS.PAY_CA_ARCHIVE dependencies on PAY_USER_COLUMNS

Line 353: pay_user_columns puc

349: puc.user_column_name
350: from
351: per_assignments_f paf,
352: hr_soft_coding_keyflex hsck,
353: pay_user_columns puc
354: where
355: paf.assignment_id = p_asg_id and
356: paf.business_group_id = p_business_group_id and
357: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and

Line 364: l_user_column_name pay_user_columns.user_column_name%TYPE;

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