APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_USER_COLUMNS

Line 714: pay_user_columns puc

710: ,cp_workschedule IN VARCHAR2 ) IS
711: SELECT sum(decode(to_number(puci.value),0,0,1)) total_days
712: ,sum(to_number(puci.value)) total_hours
713: FROM pay_user_column_instances_f puci,
714: pay_user_columns puc
715: WHERE puc.user_column_name = cp_workschedule
716: AND ( puc.legislation_code = 'MX' OR
717: puc.business_group_id = cp_business_group_id )
718: AND puc.user_column_id = puci.user_column_id;

Line 3585: pay_user_columns puc

3581: CURSOR c_work_schdl ( cp_soft_cod_kflx_id IN NUMBER ) IS
3582: SELECT hsc.segment6 salary_type
3583: ,puc.user_column_name work_schedule
3584: FROM hr_soft_coding_keyflex hsc,
3585: pay_user_columns puc
3586: WHERE hsc.soft_coding_keyflex_id = cp_soft_cod_kflx_id
3587: AND hsc.segment4 = puc.user_column_id(+);
3588:
3589: CURSOR c_location ( cp_location_id IN NUMBER ) IS