APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_USER_COLUMNS

Line 783: pay_user_columns puc

779: ,cp_workschedule IN VARCHAR2 ) IS
780: SELECT sum(decode(to_number(puci.value),0,0,1)) total_days
781: ,sum(to_number(puci.value)) total_hours
782: FROM pay_user_column_instances_f puci,
783: pay_user_columns puc
784: WHERE puc.user_column_name = cp_workschedule
785: AND ( puc.legislation_code = 'MX' OR
786: puc.business_group_id = cp_business_group_id )
787: AND puc.user_column_id = puci.user_column_id;

Line 3798: pay_user_columns puc

3794: CURSOR c_work_schdl ( cp_soft_cod_kflx_id IN NUMBER ) IS
3795: SELECT hsc.segment6 salary_type
3796: ,puc.user_column_name work_schedule
3797: FROM hr_soft_coding_keyflex hsc,
3798: pay_user_columns puc
3799: WHERE hsc.soft_coding_keyflex_id = cp_soft_cod_kflx_id
3800: AND hsc.segment4 = puc.user_column_id(+);
3801:
3802: CURSOR c_location ( cp_location_id IN NUMBER ) IS