APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 782: FROM pay_user_column_instances_f puci,

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