APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 713: FROM pay_user_column_instances_f puci,

709: CURSOR c_rww ( cp_business_group_id IN NUMBER
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 )